SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE members
    ([member_id] int, [first_name] varchar(11), [last_name] varchar(11), [email] varchar(32), [gender] varchar(6), [member_state] varchar(12))
;
    
CREATE TABLE ratings
    ([rating_id] int, [movie_id] int, [member_id] int, [rating] int)
;

CREATE TABLE movies
    ([movie_id] int, [movie_name] varchar(87), [movie_genre] varchar(34))
;

ALTER TABLE ratings ADD CONSTRAINT movies_fk FOREIGN KEY (movie_id) REFERENCES movies(movie_id);
    
ALTER TABLE ratings ADD CONSTRAINT members_fk FOREIGN KEY (member_id) REFERENCES members(member_id);
    
                
Msg 1776 Level 16 State 0 Line 13
There are no primary or candidate keys in the referenced table 'movies' that match the referencing column list in the foreign key 'movies_fk'.
Msg 1750 Level 16 State 1 Line 13
Could not create constraint or index. See previous errors.

INSERT INTO members
    ([member_id], [first_name], [last_name], [email], [gender], [member_state])
VALUES
    (1, 'Roby', 'Dauncey', 'rdauncey0@shareasale.com', 'Female', 'Maryland'),
    (2, 'Isa', 'Garfoot', 'igarfoot1@goo.gl', 'Female', 'Louisiana'),
    (3, 'Sullivan', 'Carletto', 'scarletto2@oracle.com', 'Male', 'Florida'),
    (4, 'Jacintha', 'Beacock', 'jbeacock3@wordpress.com', 'Female', 'Louisiana'),
    (5, 'Mikey', 'Keat', 'mkeat4@virginia.edu', 'Male', 'New York'),
    (6, 'Cindy', 'Stenett', 'cstenett5@weebly.com', 'Female', 'California'),
    (7, 'Alexina', 'Deary', 'adeary6@cnbc.com', 'Female', 'California'),
    (8, 'Perkin', 'Bachmann', 'pbachmann7@reference.com', 'Male', 'Texas'),
    (9, 'Laurie', 'Beebe', 'lbeebe8@cnbc.com', 'Female', 'Nebraska'),
    (10, 'Suzann', 'Genery', 'sgenery9@dailymail.co.uk', 'Female', 'Nebraska'),
    (11, 'Bonni', 'Bennellick', 'bbennellicka@elpais.com', 'Female', 'Texas'),
    (12, 'Jessica', 'Suter', 'jsuterb@blogtalkradio.com', 'Female', 'Oregon'),
    (13, 'Katya', 'O''Scannill', 'koscannillc@privacy.gov.au', 'Female', 'Missouri'),
    (14, 'Elmore', 'Kibel', 'ekibeld@livejournal.com', 'Male', 'Missouri'),
    (15, 'Rosemonde', 'Singers', 'rsingerse@xing.com', 'Female', 'Texas'),
    (16, 'Carlie', 'Iddon', 'ciddonf@newyorker.com', 'Male', 'New York'),
    (17, 'Star', 'Kitteridge', 'skitteridgeg@ca.gov', 'Female', 'Florida'),
    (18, 'Helli', 'Marzellano', 'hmarzellanoh@prnewswire.com', 'Female', 'Colorado'),
    (19, 'Isabeau', 'McInulty', 'imcinultyi@thetimes.co.uk', 'Female', 'Oregon'),
    (20, 'Felicity', 'Vigne', 'fvignej@fotki.com', 'Female', 'Kansas'),
    (21, 'Talya', 'German', 'tgermank@prlog.org', 'Female', 'Pennsylvania'),
    (22, 'Barthel', 'Turbayne', 'bturbaynel@vinaora.com', 'Male', 'California'),
    (23, 'Twila', 'Coye', 'tcoyem@disqus.com', 'Female', 'California'),
    (24, 'Trix', 'Rarity', 'trarityn@ehow.com', 'Female', 'Indiana'),
    (25, 'Danika', 'Boribal', 'dboribalo@bluehost.com', 'Female', 'New York'),
    (26, 'Lula', 'Lefridge', 'llefridgep@gnu.org', 'Female', 'Pennsylvania'),
    (27, 'Myrah', 'Hazelgreave', 'mhazelgreaveq@purevolume.com', 'Female', 'Illinois'),
    (28, 'Bibi', 'Dugdale', 'bdugdaler@apache.org', 'Female', 'Indiana'),
    (29, 'Nap', 'Jankin', 'njankins@godaddy.com', 'Male', 'Ohio'),
    (30, 'Therese', 'Shellcross', 'tshellcrosst@ucoz.com', 'Female', 'Alabama'),
    (31, 'Linc', 'Conichie', 'lconichieu@blogtalkradio.com', 'Male', 'Kansas'),
    (32, 'Dasi', 'Rraundl', 'drraundlv@member_state.gov', 'Female', 'Iowa'),
    (33, 'Chick', 'Edeler', 'cedelerw@4shared.com', 'Male', 'California'),
    (34, 'Minnaminnie', 'Genny', 'mgennyx@reddit.com', 'Female', 'Louisiana'),
    (35, 'Blane', 'Castelletti', 'bcastellettiy@member_state.tx.us', 'Male', 'Ohio'),
    (36, 'Leese', 'Beldon', 'lbeldonz@thetimes.co.uk', 'Female', 'Georgia'),
    (37, 'Mill', 'Pinchbeck', 'mpinchbeck10@google.com', 'Male', 'Texas'),
    (38, 'Nat', 'Huckster', 'nhuckster11@github.io', 'Male', 'Louisiana'),
    (39, 'Horatius', 'Baukham', 'hbaukham12@bravesites.com', 'Male', 'Minnesota'),
    (40, 'Darby', 'Hewins', 'dhewins13@tmall.com', 'Male', 'New York'),
    (41, 'Bendicty', 'Willisch', 'bwillisch14@bbc.co.uk', 'Male', 'Delaware'),
    (42, 'Danita', 'McUre', 'dmcure15@canalblog.com', 'Female', 'Wisconsin'),
    (43, 'Merrily', 'Heindl', 'mheindl16@nps.gov', 'Female', 'Wisconsin'),
    (44, 'Ginger', 'Stanwix', 'gstanwix17@independent.co.uk', 'Female', 'Indiana'),
    (45, 'Willyt', 'Bezemer', 'wbezemer18@ycombinator.com', 'Female', 'Louisiana'),
    (46, 'Latrena', 'Duffit', 'lduffit19@dell.com', 'Female', 'Kansas'),
    (47, 'Illa', 'August', 'iaugust1a@ox.ac.uk', 'Female', 'Virginia'),
    (48, 'Steffen', 'Simmers', 'ssimmers1b@google.com', 'Male', 'Arizona'),
    (49, 'Ashil', 'Sanchez', 'asanchez1c@themeforest.net', 'Female', 'Kansas'),
    (50, 'Vivian', 'Franckton', 'vfranckton1d@istockphoto.com', 'Female', 'Louisiana')
;



INSERT INTO movies
    ([movie_id], [movie_name], [movie_genre])
VALUES
    (1, 'Stalingrad', 'Drama|War'),
    (2, 'Hell Is for Heroes', 'Drama|War'),
    (3, 'White Sheik, The (Sceicco bianco, Lo)', 'Comedy|Romance'),
    (4, 'Moog', 'Documentary|Musical'),
    (5, 'Angst', 'Drama|Horror'),
    (6, 'Kid Brother, The', 'Children|Comedy|Romance'),
    (7, 'Trial and Error', 'Comedy|Romance'),
    (8, 'Code Name Coq Rouge', '(no genres listed)'),
    (9, 'Family Guy Presents: Blue Harvest', 'Animation|Comedy'),
    (10, 'The Bloody Olive', 'Comedy|Crime|Film-Noir'),
    (11, 'Red Spectacles, The (Jigoku no banken: akai megane)', 'Comedy|Drama|Sci-Fi'),
    (12, 'Ulysses'' Gaze (To Vlemma tou Odyssea)', 'Drama|War'),
    (13, 'Ring of Bright Water', 'Comedy|Drama'),
    (14, 'Flight of the Conchords: A Texan Odyssey', 'Comedy'),
    (15, 'Last Days', 'Drama'),
    (16, 'My Dinner with André', 'Drama'),
    (17, 'Homicidal', 'Horror|Mystery|Thriller'),
    (18, 'Disneyland Dream', 'Documentary'),
    (19, 'Suriyothai (a.k.a. Legend of Suriyothai, The)', 'Action|Adventure|Drama|War'),
    (20, 'Notes on a Scandal', 'Drama'),
    (21, 'Tree of Life, The', 'Drama'),
    (22, 'Up Close and Personal', 'Drama|Romance'),
    (23, 'Cadillac Records', 'Drama|Musical'),
    (24, 'Summit, The', 'Documentary'),
    (25, 'Road Trip', 'Comedy'),
    (26, 'Support Your Local Gunfighter', 'Comedy|Romance|Western'),
    (27, 'Two Solutions for One Problem (Dow Rahehal Baraye yek Massaleh)', '(no genres listed)'),
    (28, 'Momma''s Man', 'Drama'),
    (29, 'Das Leben ist nichts für Feiglinge', 'Drama'),
    (30, 'Babe Ruth Story, The', 'Drama'),
    (31, 'Believer, The', 'Drama'),
    (32, 'Unprecedented: The 2000 Presidential Election', 'Documentary'),
    (33, 'Places in the Heart', 'Drama'),
    (34, 'Prinsessa (Starring Maja)', 'Drama'),
    (35, 'In Bloom (Grzeli nateli dgeebi)', 'Drama'),
    (36, 'Spirit Trap', 'Horror|Thriller'),
    (37, 'Great World of Sound', 'Comedy'),
    (38, 'Buccaneer, The', 'Adventure|Drama|Romance|War'),
    (39, 'Possessed (Besat)', 'Action|Crime|Drama|Horror|Thriller'),
    (40, 'Children Who Chase Lost Voices from Deep Below (Hoshi o ou kodomo) (Journey to Agartha)', 'Animation|Drama|Fantasy'),
    (41, 'Our Little Girl', 'Comedy|Drama|Romance'),
    (42, 'RV', 'Adventure|Children|Comedy'),
    (43, 'Little Manhattan', 'Children|Comedy|Romance'),
    (44, 'Shining, The', 'Horror'),
    (45, 'The Old Gun', 'Drama|Thriller|War'),
    (46, 'Love Games', 'Animation|Drama|Romance'),
    (47, 'Swiss Family Robinson', 'Adventure|Children'),
    (48, 'Wedding Gift, The', 'Drama|Romance'),
    (49, 'Rocco and His Brothers (Rocco e i suoi fratelli)', 'Crime|Drama'),
    (50, 'Happiness', 'Documentary')
;



INSERT INTO ratings
    ([rating_id], [movie_id], [member_id], [rating])
VALUES
    (1, 22, 334, 1),
    (2, 87, 231, 4),
    (3, 97, 199, 1),
    (4, 37, 118, 2),
    (5, 78, 315, 5),
    (6, 79, 135, 4),
    (7, 14, 450, 5),
    (8, 73, 57, 1),
    (9, 44, 503, 3),
    (10, 56, 41, 1),
    (11, 30, 418, 5),
    (12, 36, 894, 3),
    (13, 74, 861, 5),
    (14, 42, 190, 4),
    (15, 87, 145, 3),
    (16, 36, 557, 1),
    (17, 82, 98, 1),
    (18, 62, 212, 3),
    (19, 10, 39, 2),
    (20, 50, 947, 2),
    (21, 96, 319, 5),
    (22, 10, 467, 5),
    (23, 84, 749, 4),
    (24, 21, 355, 2),
    (25, 27, 160, 3),
    (26, 9, 646, 3),
    (27, 97, 525, 4),
    (28, 21, 145, 1),
    (29, 87, 373, 3),
    (30, 51, 980, 1),
    (31, 24, 988, 2),
    (32, 93, 938, 3),
    (33, 17, 811, 5),
    (34, 40, 470, 2),
    (35, 93, 605, 1),
    (36, 52, 904, 4),
    (37, 21, 144, 5),
    (38, 49, 95, 2),
    (39, 48, 797, 3),
    (40, 57, 359, 3),
    (41, 5, 246, 5),
    (42, 65, 938, 1),
    (43, 96, 215, 4),
    (44, 44, 883, 1),
    (45, 14, 990, 4),
    (46, 1, 83, 1),
    (47, 83, 246, 5),
    (48, 64, 552, 4),
    (49, 26, 480, 4),
    (50, 48, 713, 3)
;

    
150 rows affected

    SELECT * FROM members 
    SELECT * FROM movies
    SELECT * FROM ratings


member_id
first_name
last_name
email
gender
member_state


1
Roby
Dauncey
rdauncey0@shareasale.com
Female
Maryland

2
Isa
Garfoot
igarfoot1@goo.gl
Female
Louisiana

3
Sullivan
Carletto
scarletto2@oracle.com
Male
Florida

4
Jacintha
Beacock
jbeacock3@wordpress.com
Female
Louisiana

5
Mikey
Keat
mkeat4@virginia.edu
Male
New York

6
Cindy
Stenett
cstenett5@weebly.com
Female
California

7
Alexina
Deary
adeary6@cnbc.com
Female
California

8
Perkin
Bachmann
pbachmann7@reference.com
Male
Texas

9
Laurie
Beebe
lbeebe8@cnbc.com
Female
Nebraska

10
Suzann
Genery
sgenery9@dailymail.co.uk
Female
Nebraska

11
Bonni
Bennellick
bbennellicka@elpais.com
Female
Texas

12
Jessica
Suter
jsuterb@blogtalkradio.com
Female
Oregon

13
Katya
O'Scannill
koscannillc@privacy.gov.au
Female
Missouri

14
Elmore
Kibel
ekibeld@livejournal.com
Male
Missouri

15
Rosemonde
Singers
rsingerse@xing.com
Female
Texas

16
Carlie
Iddon
ciddonf@newyorker.com
Male
New York

17
Star
Kitteridge
skitteridgeg@ca.gov
Female
Florida

18
Helli
Marzellano
hmarzellanoh@prnewswire.com
Female
Colorado

19
Isabeau
McInulty
imcinultyi@thetimes.co.uk
Female
Oregon

20
Felicity
Vigne
fvignej@fotki.com
Female
Kansas

21
Talya
German
tgermank@prlog.org
Female
Pennsylvania

22
Barthel
Turbayne
bturbaynel@vinaora.com
Male
California

23
Twila
Coye
tcoyem@disqus.com
Female
California

24
Trix
Rarity
trarityn@ehow.com
Female
Indiana

25
Danika
Boribal
dboribalo@bluehost.com
Female
New York

26
Lula
Lefridge
llefridgep@gnu.org
Female
Pennsylvania

27
Myrah
Hazelgreave
mhazelgreaveq@purevolume.com
Female
Illinois

28
Bibi
Dugdale
bdugdaler@apache.org
Female
Indiana

29
Nap
Jankin
njankins@godaddy.com
Male
Ohio

30
Therese
Shellcross
tshellcrosst@ucoz.com
Female
Alabama

31
Linc
Conichie
lconichieu@blogtalkradio.com
Male
Kansas

32
Dasi
Rraundl
drraundlv@member_state.gov
Female
Iowa

33
Chick
Edeler
cedelerw@4shared.com
Male
California

34
Minnaminnie
Genny
mgennyx@reddit.com
Female
Louisiana

35
Blane
Castelletti
bcastellettiy@member_state.tx.us
Male
Ohio

36
Leese
Beldon
lbeldonz@thetimes.co.uk
Female
Georgia

37
Mill
Pinchbeck
mpinchbeck10@google.com
Male
Texas

38
Nat
Huckster
nhuckster11@github.io
Male
Louisiana

39
Horatius
Baukham
hbaukham12@bravesites.com
Male
Minnesota

40
Darby
Hewins
dhewins13@tmall.com
Male
New York

41
Bendicty
Willisch
bwillisch14@bbc.co.uk
Male
Delaware

42
Danita
McUre
dmcure15@canalblog.com
Female
Wisconsin

43
Merrily
Heindl
mheindl16@nps.gov
Female
Wisconsin

44
Ginger
Stanwix
gstanwix17@independent.co.uk
Female
Indiana

45
Willyt
Bezemer
wbezemer18@ycombinator.com
Female
Louisiana

46
Latrena
Duffit
lduffit19@dell.com
Female
Kansas

47
Illa
August
iaugust1a@ox.ac.uk
Female
Virginia

48
Steffen
Simmers
ssimmers1b@google.com
Male
Arizona

49
Ashil
Sanchez
asanchez1c@themeforest.net
Female
Kansas

50
Vivian
Franckton
vfranckton1d@istockphoto.com
Female
Louisiana




movie_id
movie_name
movie_genre


1
Stalingrad
Drama|War

2
Hell Is for Heroes
Drama|War

3
White Sheik, The (Sceicco bianco, Lo)
Comedy|Romance

4
Moog
Documentary|Musical

5
Angst
Drama|Horror

6
Kid Brother, The
Children|Comedy|Romance

7
Trial and Error
Comedy|Romance

8
Code Name Coq Rouge
(no genres listed)

9
Family Guy Presents: Blue Harvest
Animation|Comedy

10
The Bloody Olive
Comedy|Crime|Film-Noir

11
Red Spectacles, The (Jigoku no banken: akai megane)
Comedy|Drama|Sci-Fi

12
Ulysses' Gaze (To Vlemma tou Odyssea)
Drama|War

13
Ring of Bright Water
Comedy|Drama

14
Flight of the Conchords: A Texan Odyssey
Comedy

15
Last Days
Drama

16
My Dinner with André
Drama

17
Homicidal
Horror|Mystery|Thriller

18
Disneyland Dream
Documentary

19
Suriyothai (a.k.a. Legend of Suriyothai, The)
Action|Adventure|Drama|War

20
Notes on a Scandal
Drama

21
Tree of Life, The
Drama

22
Up Close and Personal
Drama|Romance

23
Cadillac Records
Drama|Musical

24
Summit, The
Documentary

25
Road Trip
Comedy

26
Support Your Local Gunfighter
Comedy|Romance|Western

27
Two Solutions for One Problem (Dow Rahehal Baraye yek Massaleh)
(no genres listed)

28
Momma's Man
Drama

29
Das Leben ist nichts für Feiglinge
Drama

30
Babe Ruth Story, The
Drama

31
Believer, The
Drama

32
Unprecedented: The 2000 Presidential Election
Documentary

33
Places in the Heart
Drama

34
Prinsessa (Starring Maja)
Drama

35
In Bloom (Grzeli nateli dgeebi)
Drama

36
Spirit Trap
Horror|Thriller

37
Great World of Sound
Comedy

38
Buccaneer, The
Adventure|Drama|Romance|War

39
Possessed (Besat)
Action|Crime|Drama|Horror|Thriller

40
Children Who Chase Lost Voices from Deep Below (Hoshi o ou kodomo) (Journey to Agartha)
Animation|Drama|Fantasy

41
Our Little Girl
Comedy|Drama|Romance

42
RV
Adventure|Children|Comedy

43
Little Manhattan
Children|Comedy|Romance

44
Shining, The
Horror

45
The Old Gun
Drama|Thriller|War

46
Love Games
Animation|Drama|Romance

47
Swiss Family Robinson
Adventure|Children

48
Wedding Gift, The
Drama|Romance

49
Rocco and His Brothers (Rocco e i suoi fratelli)
Crime|Drama

50
Happiness
Documentary




rating_id
movie_id
member_id
rating


1
22
334
1

2
87
231
4

3
97
199
1

4
37
118
2

5
78
315
5

6
79
135
4

7
14
450
5

8
73
57
1

9
44
503
3

10
56
41
1

11
30
418
5

12
36
894
3

13
74
861
5

14
42
190
4

15
87
145
3

16
36
557
1

17
82
98
1

18
62
212
3

19
10
39
2

20
50
947
2

21
96
319
5

22
10
467
5

23
84
749
4

24
21
355
2

25
27
160
3

26
9
646
3

27
97
525
4

28
21
145
1

29
87
373
3

30
51
980
1

31
24
988
2

32
93
938
3

33
17
811
5

34
40
470
2

35
93
605
1

36
52
904
4

37
21
144
5

38
49
95
2

39
48
797
3

40
57
359
3

41
5
246
5

42
65
938
1

43
96
215
4

44
44
883
1

45
14
990
4

46
1
83
1

47
83
246
5

48
64
552
4

49
26
480
4

50
48
713
3

member_id	first_name	last_name	email	gender	member_state
1	Roby	Dauncey	rdauncey0@shareasale.com	Female	Maryland
2	Isa	Garfoot	igarfoot1@goo.gl	Female	Louisiana
3	Sullivan	Carletto	scarletto2@oracle.com	Male	Florida
4	Jacintha	Beacock	jbeacock3@wordpress.com	Female	Louisiana
5	Mikey	Keat	mkeat4@virginia.edu	Male	New York
6	Cindy	Stenett	cstenett5@weebly.com	Female	California
7	Alexina	Deary	adeary6@cnbc.com	Female	California
8	Perkin	Bachmann	pbachmann7@reference.com	Male	Texas
9	Laurie	Beebe	lbeebe8@cnbc.com	Female	Nebraska
10	Suzann	Genery	sgenery9@dailymail.co.uk	Female	Nebraska
11	Bonni	Bennellick	bbennellicka@elpais.com	Female	Texas
12	Jessica	Suter	jsuterb@blogtalkradio.com	Female	Oregon
13	Katya	O'Scannill	koscannillc@privacy.gov.au	Female	Missouri
14	Elmore	Kibel	ekibeld@livejournal.com	Male	Missouri
15	Rosemonde	Singers	rsingerse@xing.com	Female	Texas
16	Carlie	Iddon	ciddonf@newyorker.com	Male	New York
17	Star	Kitteridge	skitteridgeg@ca.gov	Female	Florida
18	Helli	Marzellano	hmarzellanoh@prnewswire.com	Female	Colorado
19	Isabeau	McInulty	imcinultyi@thetimes.co.uk	Female	Oregon
20	Felicity	Vigne	fvignej@fotki.com	Female	Kansas
21	Talya	German	tgermank@prlog.org	Female	Pennsylvania
22	Barthel	Turbayne	bturbaynel@vinaora.com	Male	California
23	Twila	Coye	tcoyem@disqus.com	Female	California
24	Trix	Rarity	trarityn@ehow.com	Female	Indiana
25	Danika	Boribal	dboribalo@bluehost.com	Female	New York
26	Lula	Lefridge	llefridgep@gnu.org	Female	Pennsylvania
27	Myrah	Hazelgreave	mhazelgreaveq@purevolume.com	Female	Illinois
28	Bibi	Dugdale	bdugdaler@apache.org	Female	Indiana
29	Nap	Jankin	njankins@godaddy.com	Male	Ohio
30	Therese	Shellcross	tshellcrosst@ucoz.com	Female	Alabama
31	Linc	Conichie	lconichieu@blogtalkradio.com	Male	Kansas
32	Dasi	Rraundl	drraundlv@member_state.gov	Female	Iowa
33	Chick	Edeler	cedelerw@4shared.com	Male	California
34	Minnaminnie	Genny	mgennyx@reddit.com	Female	Louisiana
35	Blane	Castelletti	bcastellettiy@member_state.tx.us	Male	Ohio
36	Leese	Beldon	lbeldonz@thetimes.co.uk	Female	Georgia
37	Mill	Pinchbeck	mpinchbeck10@google.com	Male	Texas
38	Nat	Huckster	nhuckster11@github.io	Male	Louisiana
39	Horatius	Baukham	hbaukham12@bravesites.com	Male	Minnesota
40	Darby	Hewins	dhewins13@tmall.com	Male	New York
41	Bendicty	Willisch	bwillisch14@bbc.co.uk	Male	Delaware
42	Danita	McUre	dmcure15@canalblog.com	Female	Wisconsin
43	Merrily	Heindl	mheindl16@nps.gov	Female	Wisconsin
44	Ginger	Stanwix	gstanwix17@independent.co.uk	Female	Indiana
45	Willyt	Bezemer	wbezemer18@ycombinator.com	Female	Louisiana
46	Latrena	Duffit	lduffit19@dell.com	Female	Kansas
47	Illa	August	iaugust1a@ox.ac.uk	Female	Virginia
48	Steffen	Simmers	ssimmers1b@google.com	Male	Arizona
49	Ashil	Sanchez	asanchez1c@themeforest.net	Female	Kansas
50	Vivian	Franckton	vfranckton1d@istockphoto.com	Female	Louisiana

movie_id	movie_name	movie_genre
1	Stalingrad	Drama\|War
2	Hell Is for Heroes	Drama\|War
3	White Sheik, The (Sceicco bianco, Lo)	Comedy\|Romance
4	Moog	Documentary\|Musical
5	Angst	Drama\|Horror
6	Kid Brother, The	Children\|Comedy\|Romance
7	Trial and Error	Comedy\|Romance
8	Code Name Coq Rouge	(no genres listed)
9	Family Guy Presents: Blue Harvest	Animation\|Comedy
10	The Bloody Olive	Comedy\|Crime\|Film-Noir
11	Red Spectacles, The (Jigoku no banken: akai megane)	Comedy\|Drama\|Sci-Fi
12	Ulysses' Gaze (To Vlemma tou Odyssea)	Drama\|War
13	Ring of Bright Water	Comedy\|Drama
14	Flight of the Conchords: A Texan Odyssey	Comedy
15	Last Days	Drama
16	My Dinner with André	Drama
17	Homicidal	Horror\|Mystery\|Thriller
18	Disneyland Dream	Documentary
19	Suriyothai (a.k.a. Legend of Suriyothai, The)	Action\|Adventure\|Drama\|War
20	Notes on a Scandal	Drama
21	Tree of Life, The	Drama
22	Up Close and Personal	Drama\|Romance
23	Cadillac Records	Drama\|Musical
24	Summit, The	Documentary
25	Road Trip	Comedy
26	Support Your Local Gunfighter	Comedy\|Romance\|Western
27	Two Solutions for One Problem (Dow Rahehal Baraye yek Massaleh)	(no genres listed)
28	Momma's Man	Drama
29	Das Leben ist nichts für Feiglinge	Drama
30	Babe Ruth Story, The	Drama
31	Believer, The	Drama
32	Unprecedented: The 2000 Presidential Election	Documentary
33	Places in the Heart	Drama
34	Prinsessa (Starring Maja)	Drama
35	In Bloom (Grzeli nateli dgeebi)	Drama
36	Spirit Trap	Horror\|Thriller
37	Great World of Sound	Comedy
38	Buccaneer, The	Adventure\|Drama\|Romance\|War
39	Possessed (Besat)	Action\|Crime\|Drama\|Horror\|Thriller
40	Children Who Chase Lost Voices from Deep Below (Hoshi o ou kodomo) (Journey to Agartha)	Animation\|Drama\|Fantasy
41	Our Little Girl	Comedy\|Drama\|Romance
42	RV	Adventure\|Children\|Comedy
43	Little Manhattan	Children\|Comedy\|Romance
44	Shining, The	Horror
45	The Old Gun	Drama\|Thriller\|War
46	Love Games	Animation\|Drama\|Romance
47	Swiss Family Robinson	Adventure\|Children
48	Wedding Gift, The	Drama\|Romance
49	Rocco and His Brothers (Rocco e i suoi fratelli)	Crime\|Drama
50	Happiness	Documentary

rating_id	movie_id	member_id	rating
1	22	334	1
2	87	231	4
3	97	199	1
4	37	118	2
5	78	315	5
6	79	135	4
7	14	450	5
8	73	57	1
9	44	503	3
10	56	41	1
11	30	418	5
12	36	894	3
13	74	861	5
14	42	190	4
15	87	145	3
16	36	557	1
17	82	98	1
18	62	212	3
19	10	39	2
20	50	947	2
21	96	319	5
22	10	467	5
23	84	749	4
24	21	355	2
25	27	160	3
26	9	646	3
27	97	525	4
28	21	145	1
29	87	373	3
30	51	980	1
31	24	988	2
32	93	938	3
33	17	811	5
34	40	470	2
35	93	605	1
36	52	904	4
37	21	144	5
38	49	95	2
39	48	797	3
40	57	359	3
41	5	246	5
42	65	938	1
43	96	215	4
44	44	883	1
45	14	990	4
46	1	83	1
47	83	246	5
48	64	552	4
49	26	480	4
50	48	713	3

rating_id	movie_id	member_id	rating
1	22	334	1
2	87	231	4
3	97	199	1
4	37	118	2
5	78	315	5
6	79	135	4
7	14	450	5
8	73	57	1
9	44	503	3
10	56	41	1
11	30	418	5
12	36	894	3
13	74	861	5
14	42	190	4
15	87	145	3
16	36	557	1
17	82	98	1
18	62	212	3
19	10	39	2
20	50	947	2
21	96	319	5
22	10	467	5
23	84	749	4
24	21	355	2
25	27	160	3
26	9	646	3
27	97	525	4
28	21	145	1
29	87	373	3
30	51	980	1
31	24	988	2
32	93	938	3
33	17	811	5
34	40	470	2
35	93	605	1
36	52	904	4
37	21	144	5
38	49	95	2
39	48	797	3
40	57	359	3
41	5	246	5
42	65	938	1
43	96	215	4
44	44	883	1
45	14	990	4
46	1	83	1
47	83	246	5
48	64	552	4
49	26	480	4
50	48	713	3

rating_id	movie_id	member_id	rating
1	22	334	1
2	87	231	4
3	97	199	1
4	37	118	2
5	78	315	5
6	79	135	4
7	14	450	5
8	73	57	1
9	44	503	3
10	56	41	1
11	30	418	5
12	36	894	3
13	74	861	5
14	42	190	4
15	87	145	3
16	36	557	1
17	82	98	1
18	62	212	3
19	10	39	2
20	50	947	2
21	96	319	5
22	10	467	5
23	84	749	4
24	21	355	2
25	27	160	3
26	9	646	3
27	97	525	4
28	21	145	1
29	87	373	3
30	51	980	1
31	24	988	2
32	93	938	3
33	17	811	5
34	40	470	2
35	93	605	1
36	52	904	4
37	21	144	5
38	49	95	2
39	48	797	3
40	57	359	3
41	5	246	5
42	65	938	1
43	96	215	4
44	44	883	1
45	14	990	4
46	1	83	1
47	83	246	5
48	64	552	4
49	26	480	4
50	48	713	3