w3resources is dumb

data.sql

INSERT INTO reviewer (rev_id, rev_name) VALUES(9001, 'Righty Sock')
INSERT INTO reviewer (rev_id, rev_name) VALUES(9002, 'Jack Malvern')
INSERT INTO reviewer (rev_id, rev_name) VALUES(9003, 'Flagrant Baronessa')
INSERT INTO reviewer (rev_id, rev_name) VALUES(9004, 'Alec Shaw')
INSERT INTO reviewer (rev_id, rev_name) VALUES(9005, '')
INSERT INTO reviewer (rev_id, rev_name) VALUES(9006, 'Victor Woeltjen')
INSERT INTO reviewer (rev_id, rev_name) VALUES(9007, 'Simon Wright')
INSERT INTO reviewer (rev_id, rev_name) VALUES(9008, 'Neal Wruck')
INSERT INTO reviewer (rev_id, rev_name) VALUES(9009, 'Paul Monks')
INSERT INTO reviewer (rev_id, rev_name) VALUES(9010, 'Mike Salvati')
INSERT INTO reviewer (rev_id, rev_name) VALUES(9011, '')
INSERT INTO reviewer (rev_id, rev_name) VALUES(9012, 'Wesley S. Walker')
INSERT INTO reviewer (rev_id, rev_name) VALUES(9013, 'Sasha Goldshtein')
INSERT INTO reviewer (rev_id, rev_name) VALUES(9014, 'Josh Cates')
INSERT INTO reviewer (rev_id, rev_name) VALUES(9015, 'Krug Stillo')
INSERT INTO reviewer (rev_id, rev_name) VALUES(9016, 'Scott LeBrun')
INSERT INTO reviewer (rev_id, rev_name) VALUES(9017, 'Hannah Steele')
INSERT INTO reviewer (rev_id, rev_name) VALUES(9018, 'Vincent Cadena')
INSERT INTO reviewer (rev_id, rev_name) VALUES(9019, 'Brandt Sponseller')
INSERT INTO reviewer (rev_id, rev_name) VALUES(9020, 'Richard Adams')

INSERT INTO actor VALUES
    (101,N'James',N'Stewart',N'M'),
    (102,N'Deborah',N'Kerr',N'F'),
    (103,N'Peter',N'OToole',N'M'),
    (104,N'Robert',N'De Niro',N'M'),
    (105,N'F. Murray',N'Abraham',N'M'),
    (106,N'Harrison',N'Ford',N'M'),
    (107,N'Nicole',N'Kidman',N'F'),
    (108,N'Stephen',N'Baldwin',N'M'),
    (109,N'Jack',N'Nicholson',N'M'),
    (110,N'Mark',N'Wahlberg',N'M'),
    (111,N'Woody',N'Allen',N'M'),
    (112,N'Claire',N'Danes',N'F'),
    (113,N'Tim',N'Robbins',N'M'),
    (114,N'Kevin',N'Spacey',N'M'),
    (115,N'Kate',N'Winslet',N'F'),
    (116,N'Robin',N'Williams',N'M'),
    (117,N'Jon',N'Voight',N'M'),
    (118,N'Ewan',N'McGregor',N'M'),
    (119,N'Christian',N'Bale',N'M'),
    (120,N'Maggie',N'Gyllenhaal',N'F'),
    (121,N'Dev',N'Patel',N'M'),
    (122,N'Sigourney',N'Weaver',N'F'),
    (123,N'David',N'Aston',N'M'),
    (124,N'Ali',N'Astin',N'F');


    INSERT INTO director VALUES
    (201,N'Alfred',N'Hitchcock'),
    (202,N'Jack',N'Clayton'),
    (203,N'David',N'Lean'),
    (204,N'Michael',N'Cimino'),
    (205,N'Milos',N'Forman'),
    (206,N'Ridley',N'Scott'),
    (207,N'Stanley',N'Kubrick'),
    (208,N'Bryan',N'Singer'),
    (209,N'Roman',N'Polanski'),
    (210,N'Paul',N'Thomas Anderson'),
    (211,N'Woody',N'Allen'),
    (212,N'Hayao',N'Miyazaki'),
    (213,N'Frank',N'Darabont'),
    (214,N'Sam',N'Mendes'),
    (215,N'James',N'Cameron'),
    (216,N'Gus',N'Van Sant'),
    (217,N'John',N'Boorman'),
    (218,N'Danny',N'Boyle'),
    (219,N'Christopher',N'Nolan'),
    (220,N'Richard',N'Kelly'),
    (221,N'Kevin',N'Spacey'),
    (222,N'Andrei',N'Tarkovsky'),
    (223,N'Peter',N'Jackson');

INSERT INTO movie VALUES
    (901,N'Vertigo',1958,128,N'English',N' UK'),
    (902,N'The Innocents',1961,100,N'English',N' SW'),
    (903,N'Lawrence of Arabia',1962,216,N'English',N' UK'),
    (904,N'The Deer Hunter',1978,183,N'English',N' UK'),
    (905,N'Amadeus',1984,160,N'English',N' UK'),
    (906,N'Blade Runner',1982,117,N'English',N' UK'),
    (907,N'Eyes Wide Shut',1999,159,N'English',N' UK'),
    (908,N'The Usual Suspects',1995,106,N'English',N' UK'),
    (909,N'Chinatown',1974,130,N'English',N' UK'),
    (910,N'Boogie Nights',1997,155,N'English',N' UK'),
    (911,N'Annie Hall',1977,93,N'English',N' USA'),
    (912,N'Princess Mononoke',1997,134,N'Japanese',N' UK'),
    (913,N'The Shawshank Redemption',1994,142,N'English',N' UK'),
    (914,N'American Beauty',1999,122,N'English',N' UK'),
    (915,N'Titanic',1997,194,N'English',N' UK'),
    (916,N'Good Will Hunting',1997,126,N'English',N' UK'),
    (917,N'Deliverance',1972,109,N'English',N' UK'),
    (918,N'Trainspotting',1996,94,N'English',N' UK'),
    (919,N'The Prestige',2006,130,N'English',N' UK'),
    (920,N'Donnie Darko',2001,113,N'English',N' UK'),
    (921,N'Slumdog Millionaire',2008,120,N'English',N' UK'),
    (922,N'Aliens',1986,137,N'English',N' UK'),
    (923,N'Beyond the Sea',2004,118,N'English',N' UK'),
    (924,N'Avatar',2009,162,N'English',N' UK'),
    (926,N'Seven Samurai',1954,207,N'Japanese',N' JP'),
    (927,N'Spirited Away',2001,125,N'Japanese',N' UK'),
    (928,N'Back to the Future',1985,116,N'English',N' UK'),
    (925,N'Braveheart',1995,178,N'English',N' UK');


    INSERT INTO reviewer VALUES
    (9001,N'Righty Sock'),
    (9002,N'Jack Malvern'),
    (9003,N'Flagrant Baronessa'),
    (9004,N'Alec Shaw'),
    (9005,NULL),
    (9006,N'Victor Woeltjen'),
    (9007,N'Simon Wright'),
    (9008,N'Neal Wruck'),
    (9009,N'Paul Monks'),
    (9010,N'Mike Salvati'),
    (9011,NULL),
    (9012,N'Wesley S. Walker'),
    (9013,N'Sasha Goldshtein'),
    (9014,N'Josh Cates'),
    (9015,N'Krug Stillo'),
    (9016,N'Scott LeBrun'),
    (9017,N'Hannah Steele'),
    (9018,N'Vincent Cadena'),
    (9019,N'Brandt Sponseller'),
    (9020,N'Richard Adams');


INSERT INTO genres (gen_id, gen_title) VALUES(1001, 'Action')
INSERT INTO genres (gen_id, gen_title) VALUES(1002, 'Adventure')
INSERT INTO genres (gen_id, gen_title) VALUES(1003, 'Animation')
INSERT INTO genres (gen_id, gen_title) VALUES(1004, 'Biography')
INSERT INTO genres (gen_id, gen_title) VALUES(1005, 'Comedy')
INSERT INTO genres (gen_id, gen_title) VALUES(1006, 'Crime')
INSERT INTO genres (gen_id, gen_title) VALUES(1007, 'Drama')
INSERT INTO genres (gen_id, gen_title) VALUES(1008, 'Horror')
INSERT INTO genres (gen_id, gen_title) VALUES(1009, 'Music')
INSERT INTO genres (gen_id, gen_title) VALUES(1010, 'Mystery')
INSERT INTO genres (gen_id, gen_title) VALUES(1011, 'Romance')
INSERT INTO genres (gen_id, gen_title) VALUES(1012, 'Thriller')
INSERT INTO genres (gen_id, gen_title) VALUES(1013, 'War')


INSERT INTO movie_direction VALUES
    (201,901),
    (202,902),
    (203,903),
    (204,904),
    (205,905),
    (206,906),
    (207,907),
    (208,908),
    (209,909),
    (210,910),
    (211,911),
    (212,912),
    (213,913),
    (214,914),
    (215,915),
    (216,916),
    (217,917),
    (218,918),
    (219,919),
    (220,920),
    (218,921),
    (215,922),
    (221,923);
INSERT INTO movie_cast VALUES
    (101,901,N'John Scottie Ferguson'),
    (102,902,N'Miss Giddens'),
    (103,903,N'T.E. Lawrence'),
    (104,904,N'Michael'),
    (105,905,N'Antonio Salieri'),
    (106,906,N'Rick Deckard'),
    (107,907,N'Alice Harford'),
    (108,908,N'McManus'),
    (110,910,N'Eddie Adams'),
    (111,911,N'Alvy Singer'),
    (112,912,N'San'),
    (113,913,N'Andy Dufresne'),
    (114,914,N'Lester Burnham'),
    (115,915,N'Rose DeWitt Bukater'),
    (116,916,N'Sean Maguire'),
    (117,917,N'Ed'),
    (118,918,N'Renton'),
    (120,920,N'Elizabeth Darko'),
    (121,921,N'Older Jamal'),
    (122,922,N'Ripley'),
    (114,923,N'Bobby Darin'),
    (109,909,N'J.J. Gittes'),
    (119,919,N'Alfred Borden');



INSERT INTO movie_genres (mov_id, gen_id) VALUES(922, 1001)
INSERT INTO movie_genres (mov_id, gen_id) VALUES(917, 1002)
INSERT INTO movie_genres (mov_id, gen_id) VALUES(903, 1002)
INSERT INTO movie_genres (mov_id, gen_id) VALUES(912, 1003)
INSERT INTO movie_genres (mov_id, gen_id) VALUES(911, 1005)
INSERT INTO movie_genres (mov_id, gen_id) VALUES(908, 1006)
INSERT INTO movie_genres (mov_id, gen_id) VALUES(913, 1006)
INSERT INTO movie_genres (mov_id, gen_id) VALUES(926, 1007)
INSERT INTO movie_genres (mov_id, gen_id) VALUES(928, 1007)
INSERT INTO movie_genres (mov_id, gen_id) VALUES(918, 1007)
INSERT INTO movie_genres (mov_id, gen_id) VALUES(921, 1007)
INSERT INTO movie_genres (mov_id, gen_id) VALUES(902, 1008)
INSERT INTO movie_genres (mov_id, gen_id) VALUES(923, 1009)
INSERT INTO movie_genres (mov_id, gen_id) VALUES(907, 1010)
INSERT INTO movie_genres (mov_id, gen_id) VALUES(927, 1010)
INSERT INTO movie_genres (mov_id, gen_id) VALUES(901, 1010)
INSERT INTO movie_genres (mov_id, gen_id) VALUES(914, 1011)
INSERT INTO movie_genres (mov_id, gen_id) VALUES(906, 1012)
INSERT INTO movie_genres (mov_id, gen_id) VALUES(904, 1013)


INSERT INTO rating VALUES
    (901,9001,8.4,263575),
    (902,9002,7.9,20207),
    (903,9003,8.3,202778),
    (906,9005,8.2,484746),
    (924,9006,7.3,NULL),
    (908,9007,8.6,779489),
    (909,9008,NULL,227235),
    (910,9009,3,195961),
    (911,9010,8.1,203875),
    (912,9011,8.4,NULL),
    (914,9013,7,862618),
    (915,9001,7.7,830095),
    (916,9014,4,642132),
    (925,9015,7.7,81328),
    (918,9016,NULL,580301),
    (920,9017,8.1,609451),
    (921,9018,8,667758),
    (922,9019,8.4,511613),
    (923,9020,6.7,13091);