API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 15th, 2017
603
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 54.59 KB | None | 0 0
raw download clone embed print report
  1. CREATE TABLE Cinema (title VARCHAR(100) NOT NULL, address VARCHAR(200), volume INT, hallscount TINYINT);
  2. ALTER TABLE dbo.Cinema ADD ID INT IDENTITY;
  3. ALTER TABLE dbo.Cinema ADD CONSTRAINT PK_Cinema PRIMARY KEY(ID);
  4.  
  5. INSERT INTO Cinema VALUES ('Cineplex Cinemas Esplanade', '200 West Esplanade North Vancouver, BC, V7M 1A4', 5400, 10);
  6. INSERT INTO Cinema VALUES ('Dunbar Theatre', '4555 Dunbar Street Vancouver, BC, V6S 2G7', 9500, 9);
  7. INSERT INTO Cinema VALUES ('Fifth Avenue Cinemas', '2110 Burrard Street Vancouver, BC, V6J 3H5', 300, 4);
  8. INSERT INTO Cinema VALUES ('Hollywood Cinemas Rialto', '1732 Johnston Road (152 Street) White Rock, BC, V4B 1L3', 10000, 9);
  9. INSERT INTO Cinema VALUES ('Landmark Cinemas 12 Guildford (Empire Studio 12)', '15051 101st Avenue Surrey, BC, V3R 7Z1', 8200, 10);
  10. INSERT INTO Cinema VALUES ('OMNIMAX Theatre at Science World', '1455 Quebec Street Vancouver, BC, V6A 3Z7', 5500, 5);
  11. INSERT INTO Cinema VALUES ('Pacific Cinematheque', '1131 Howe St. Vancouver, BC, V6Z 2L7', 6000, 5);
  12. INSERT INTO Cinema VALUES ('Park & Tilford, North Vancouver', '200-333 Brooksbank Avenue North Vancouver, BC, V7J 3S8', 6300, 4);
  13. INSERT INTO Cinema VALUES ('Rio Theatre', '1660 E. Broadway Vancouver, BC, V5N 1W1', 5400, 5);
  14. INSERT INTO Cinema VALUES ('Scotiabank Theatre Vancouver', '900 Burrard Street Vancouver, BC, V6Z 3G5', 3200, 3);
  15. INSERT INTO Cinema VALUES ('SFU Woodwards', '149 West Hastings Street Vancouver, BC, V6B 1H7', 500, 4);
  16. INSERT INTO Cinema VALUES ('SilverCity Coquitlam and VIP', '170 Schoolhouse Street Coquitlam, BC, V3K 4X9', 1800, 3);
  17. INSERT INTO Cinema VALUES ('Strawberry Hills Cinemas, Surrey', '12161 72nd Ave Surrey, BC, V3W 2M1', 9900, 4);
  18. INSERT INTO Cinema VALUES ('The Landmark Cinemas 10', '390-800 Carnarvon Street F New Westminster, BC, V3M 1G2', 9300, 9);
  19. INSERT INTO Cinema VALUES ('The Park Theatre', '3440 Cambie Street Vancouver, BC, V5Z 2W8', 7300, 5);
  20. INSERT INTO Cinema VALUES ('Twilight Drive-In', '260th Street & Fraser Highway Langley, BC, V4W 2B1', 8700, 2);
  21. INSERT INTO Cinema VALUES ('Vancity Theatre', '1181 Seymour St. Vancouver, BC, V6B 3M7', 6200, 7);
  22. INSERT INTO Cinema VALUES ('Vancouver Aquarium', '845 Avison Way Vancouver, BC, V6G 3E2', 5400, 7);
  23.  
  24. CREATE TABLE Film (title VARCHAR(200) NOT NULL, genre VARCHAR(100) NOT NULL, duration INT, contentRating VARCHAR(50) NOT NULL, year DATE NOT NULL);
  25. ALTER TABLE dbo.Film ADD ID INT IDENTITY;
  26. ALTER TABLE dbo.Film ADD CONSTRAINT PK_Film PRIMARY KEY(ID);
  27.  
  28. INSERT INTO Film VALUES ('The Shawshank Redemption', 'Crime, Drama', 142, 'R', '1994');
  29. INSERT INTO Film VALUES ('The Godfather', 'Crime, Drama', 175, 'R', '1972');
  30. INSERT INTO Film VALUES ('The Godfather: Part II', 'Crime, Drama', 202, 'R', '1974');
  31. INSERT INTO Film VALUES ('The Dark Knight', 'Action, Crime, Drama', 152, 'PG-13', '2008');
  32. INSERT INTO Film VALUES ('12 Angry Men', 'Crime, Drama', 96, 'NOT RATED', '1957');
  33. INSERT INTO Film VALUES ('Schindler''s List', 'Biography, Drama, History', 195, 'R', '1993');
  34. INSERT INTO Film VALUES ('Pulp Fiction', 'Crime, Drama', 154, 'R', '1994');
  35. INSERT INTO Film VALUES ('The Lord of the Rings: The Return of the King', 'Adventure, Drama, Fantasy', 201, 'PG-13', '2003');
  36. INSERT INTO Film VALUES ('The Good, the Bad and the Ugly', 'Western', 178, 'R', '1966');
  37. INSERT INTO Film VALUES ('Fight Club', 'Drama', 139, 'R', '1999');
  38. INSERT INTO Film VALUES ('The Lord of the Rings: The Fellowship of the Ring', 'Adventure, Drama, Fantasy', 178, 'PG-13', '2001');
  39. INSERT INTO Film VALUES ('Forrest Gump', 'Drama, Romance', 142, 'PG-13', '1994');
  40. INSERT INTO Film VALUES ('Star Wars: Episode V - The Empire Strikes Back', 'Action, Adventure, Fantasy', 124, 'PG', '1980');
  41. INSERT INTO Film VALUES ('Inception', 'Action, Adventure, Sci-Fi', 148, 'PG-13', '2010');
  42. INSERT INTO Film VALUES ('The Lord of the Rings: The Two Towers', 'Adventure, Drama, Fantasy', 179, 'PG-13', '2002');
  43. INSERT INTO Film VALUES ('One Flew Over the Cuckoo''s Nest', 'Drama', 133, 'R', '1975');
  44. INSERT INTO Film VALUES ('Goodfellas', 'Biography, Crime, Drama', 146, 'R', '1990');
  45. INSERT INTO Film VALUES ('The Matrix', 'Action, Sci-Fi', 136, 'R', '1999');
  46. INSERT INTO Film VALUES ('Seven Samurai', 'Adventure, Drama', 207, 'NOT RATED', '1954');
  47. INSERT INTO Film VALUES ('Star Wars: Episode IV - A New Hope', 'Action, Adventure, Fantasy', 121, 'PG', '1977');
  48. INSERT INTO Film VALUES ('City of God', 'Crime, Drama', 130, 'R', '2002');
  49. INSERT INTO Film VALUES ('Se7en', 'Crime, Drama, Mystery', 127, 'R', '1995');
  50. INSERT INTO Film VALUES ('The Silence of the Lambs', 'Crime, Drama, Thriller', 118, 'R', '1991');
  51. INSERT INTO Film VALUES ('It''s a Wonderful Life', 'Drama, Family, Fantasy', 130, 'PG', '1946');
  52. INSERT INTO Film VALUES ('Life Is Beautiful', 'Comedy, Drama, War', 116, 'PG-13', '1997');
  53. INSERT INTO Film VALUES ('The Usual Suspects', 'Crime, Drama, Mystery', 106, 'R', '1995');
  54. INSERT INTO Film VALUES ('Léon: The Professional', 'Crime, Drama, Thriller', 110, 'R', '1994');
  55. INSERT INTO Film VALUES ('Saving Private Ryan', 'Drama, War', 169, 'R', '1998');
  56. INSERT INTO Film VALUES ('Spirited Away', 'Animation, Adventure, Family', 125, 'PG', '2001');
  57. INSERT INTO Film VALUES ('Coco', 'Animation, Adventure, Comedy', 105, 'PG', '2017');
  58. INSERT INTO Film VALUES ('American History X', 'Crime, Drama', 119, 'R', '1998');
  59. INSERT INTO Film VALUES ('Once Upon a Time in the West', 'Western', 164, 'PG-13', '1968');
  60. INSERT INTO Film VALUES ('Interstellar', 'Adventure, Drama, Sci-Fi', 169, 'PG-13', '2014');
  61. INSERT INTO Film VALUES ('The Green Mile', 'Crime, Drama, Fantasy', 189, 'R', '1999');
  62. INSERT INTO Film VALUES ('Psycho', 'Horror, Mystery, Thriller', 109, 'R', '1960');
  63. INSERT INTO Film VALUES ('City Lights', 'Comedy, Drama, Romance', 87, 'G', '1931');
  64. INSERT INTO Film VALUES ('Casablanca', 'Drama, Romance, War', 102, 'PG', '1942');
  65. INSERT INTO Film VALUES ('The Intouchables', 'Biography, Comedy, Drama', 112, 'R', '2011');
  66. INSERT INTO Film VALUES ('Modern Times', 'Comedy, Drama, Family', 87, 'PASSED', '1936');
  67. INSERT INTO Film VALUES ('The Pianist', 'Biography, Drama, Music', 150, 'R', '2002');
  68. INSERT INTO Film VALUES ('Raiders of the Lost Ark', 'Action, Adventure', 115, 'PG', '1981');
  69. INSERT INTO Film VALUES ('The Departed', 'Crime, Drama, Thriller', 151, 'R', '2006');
  70. INSERT INTO Film VALUES ('Rear Window', 'Mystery, Thriller', 112, 'PG', '1954');
  71. INSERT INTO Film VALUES ('Terminator 2', 'Action, Sci-Fi, Thriller', 137, 'R', '1991');
  72. INSERT INTO Film VALUES ('Back to the Future', 'Adventure, Comedy, Sci-Fi', 116, 'PG', '1985');
  73. INSERT INTO Film VALUES ('Whiplash', 'Drama, Music', 107, 'R', '2014');
  74. INSERT INTO Film VALUES ('Gladiator', 'Action, Adventure, Drama', 155, 'R', '2000');
  75. INSERT INTO Film VALUES ('The Lion King', 'Animation, Adventure, Drama', 88, 'G', '1994');
  76. INSERT INTO Film VALUES ('The Prestige', 'Drama, Mystery, Sci-Fi', 130, 'PG-13', '2006');
  77. INSERT INTO Film VALUES ('Memento', 'Mystery, Thriller', 113, 'R', '2000');
  78. INSERT INTO Film VALUES ('Apocalypse Now', 'Drama, War', 147, 'R', '1979');
  79. INSERT INTO Film VALUES ('Alien', 'Horror, Sci-Fi', 117, 'R', '1979');
  80. INSERT INTO Film VALUES ('The Great Dictator', 'Comedy, Drama, War', 125, 'G', '1940');
  81. INSERT INTO Film VALUES ('Sunset Blvd.', 'Drama, Film-Noir', 110, 'NOT RATED', '1950');
  82. INSERT INTO Film VALUES ('Cinema Paradiso', 'Drama', 155, 'R', '1988');
  83. INSERT INTO Film VALUES ('Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb', 'Comedy, War', 95, 'PG', '1964');
  84. INSERT INTO Film VALUES ('The Lives of Others', 'Drama, Thriller', 137, 'R', '2006');
  85. INSERT INTO Film VALUES ('Grave of the Fireflies', 'Animation, Drama, War', 89, 'NOT RATED', '1988');
  86. INSERT INTO Film VALUES ('Paths of Glory', 'Drama, War', 88, 'NOT RATED', '1957');
  87. INSERT INTO Film VALUES ('Django Unchained', 'Drama, Western', 165, 'R', '2012');
  88. INSERT INTO Film VALUES ('The Shining', 'Drama, Horror', 146, 'R', '1980');
  89. INSERT INTO Film VALUES ('WALL·E', 'Animation, Adventure, Family', 98, 'G', '2008');
  90. INSERT INTO Film VALUES ('American Beauty', 'Drama', 122, 'R', '1999');
  91. INSERT INTO Film VALUES ('Princess Mononoke', 'Animation, Adventure, Fantasy', 134, 'PG-13', '1997');
  92. INSERT INTO Film VALUES ('The Dark Knight Rises', 'Action, Thriller', 164, 'PG-13', '2012');
  93. INSERT INTO Film VALUES ('Blade Runner 2049', 'Drama, Mystery, Sci-Fi', 164, 'R', '2017');
  94. INSERT INTO Film VALUES ('Oldeuboi', 'Action, Drama, Mystery', 120, 'R', '2003');
  95. INSERT INTO Film VALUES ('Aliens', 'Action, Adventure, Sci-Fi', 137, 'R', '1986');
  96. INSERT INTO Film VALUES ('Witness for the Prosecution', 'Crime, Drama, Mystery', 116, 'NOT RATED', '1957');
  97. INSERT INTO Film VALUES ('Once Upon a Time in America', 'Crime, Drama', 229, 'R', '1984');
  98. INSERT INTO Film VALUES ('Das Boot', 'Adventure, Drama, Thriller', 149, 'R', '1981');
  99. INSERT INTO Film VALUES ('Dangal', 'Action, Biography, Drama', 161, 'UNRATED', '2016');
  100. INSERT INTO Film VALUES ('Citizen Kane', 'Drama, Mystery', 119, 'PG', '1941');
  101. INSERT INTO Film VALUES ('Vertigo', 'Mystery, Romance, Thriller', 128, 'PG', '1958');
  102. INSERT INTO Film VALUES ('North by Northwest', 'Action, Adventure, Mystery', 136, 'NOT RATED', '1959');
  103. INSERT INTO Film VALUES ('Star Wars: Episode VI - Return of the Jedi', 'Action, Adventure, Fantasy', 131, 'PG', '1983');
  104. INSERT INTO Film VALUES ('Braveheart', 'Biography, Drama, History', 178, 'R', '1995');
  105. INSERT INTO Film VALUES ('Reservoir Dogs', 'Crime, Drama, Thriller', 99, 'R', '1992');
  106. INSERT INTO Film VALUES ('M', 'Crime, Drama, Mystery', 99, 'NOT RATED', '1931');
  107. INSERT INTO Film VALUES ('Requiem for a Dream', 'Drama', 102, 'R', '2000');
  108. INSERT INTO Film VALUES ('Kimi no na wa.', 'Animation, Drama, Fantasy', 106, 'PG', '2016');
  109. INSERT INTO Film VALUES ('Taare Zameen Par', 'Drama, Family', 165, 'PG', '2007');
  110. INSERT INTO Film VALUES ('Amélie', 'Comedy, Romance', 122, 'R', '2001');
  111. INSERT INTO Film VALUES ('A Clockwork Orange', 'Crime, Drama, Sci-Fi', 136, 'R', '1971');
  112. INSERT INTO Film VALUES ('Lawrence of Arabia', 'Adventure, Biography, Drama', 216, 'PG', '1962');
  113. INSERT INTO Film VALUES ('Amadeus', 'Biography, Drama, History', 160, 'R', '1984');
  114. INSERT INTO Film VALUES ('Double Indemnity', 'Crime, Drama, Film-Noir', 107, 'NOT RATED', '1944');
  115. INSERT INTO Film VALUES ('Eternal Sunshine of the Spotless Mind', 'Drama, Romance, Sci-Fi', 108, 'R', '2004');
  116. INSERT INTO Film VALUES ('Taxi Driver', 'Crime, Drama', 113, 'R', '1976');
  117. INSERT INTO Film VALUES ('To Kill a Mockingbird', 'Crime, Drama', 129, 'NOT RATED', '1962');
  118. INSERT INTO Film VALUES ('Full Metal Jacket', 'Drama, War', 116, 'R', '1987');
  119. INSERT INTO Film VALUES ('2001: A Space Odyssey', 'Adventure, Sci-Fi', 149, 'G', '1968');
  120. INSERT INTO Film VALUES ('Singin'' in the Rain', 'Comedy, Musical, Romance', 103, 'G', '1952');
  121. INSERT INTO Film VALUES ('Toy Story', 'Animation, Adventure, Comedy', 81, 'G', '1995');
  122. INSERT INTO Film VALUES ('3 Idiots', 'Comedy, Drama', 170, 'PG-13', '2009');
  123. INSERT INTO Film VALUES ('The Sting', 'Comedy, Crime, Drama', 129, 'PG', '1973');
  124. INSERT INTO Film VALUES ('Toy Story 3', 'Animation, Adventure, Comedy', 103, 'G', '2010');
  125. INSERT INTO Film VALUES ('Inglourious Basterds', 'Adventure, Drama, War', 153, 'R', '2009');
  126. INSERT INTO Film VALUES ('Bicycle Thieves', 'Drama', 89, 'NOT RATED', '1948');
  127. INSERT INTO Film VALUES ('The Kid', 'Comedy, Drama, Family', 68, 'NOT RATED', '1921');
  128. INSERT INTO Film VALUES ('Snatch', 'Comedy, Crime', 102, 'R', '2000');
  129. INSERT INTO Film VALUES ('Monty Python and the Holy Grail', 'Adventure, Comedy, Fantasy', 91, 'PG', '1975');
  130. INSERT INTO Film VALUES ('Good Will Hunting', 'Drama', 126, 'R', '1997');
  131. INSERT INTO Film VALUES ('Jagten', 'Drama', 115, 'R', '2012');
  132. INSERT INTO Film VALUES ('For a Few Dollars More', 'Western', 132, 'R', '1965');
  133. INSERT INTO Film VALUES ('Scarface', 'Crime, Drama', 170, 'R', '1983');
  134. INSERT INTO Film VALUES ('L.A. Confidential', 'Crime, Drama, Mystery', 138, 'R', '1997');
  135. INSERT INTO Film VALUES ('The Apartment', 'Comedy, Drama, Romance', 125, 'NOT RATED', '1960');
  136. INSERT INTO Film VALUES ('Metropolis', 'Drama, Sci-Fi', 153, 'NOT RATED', '1927');
  137. INSERT INTO Film VALUES ('A Separation', 'Drama, Mystery', 123, 'PG-13', '2011');
  138. INSERT INTO Film VALUES ('Rashômon', 'Crime, Drama, Mystery', 88, 'NOT RATED', '1950');
  139. INSERT INTO Film VALUES ('Indiana Jones and the Last Crusade', 'Action, Adventure, Fantasy', 127, 'PG-13', '1989');
  140. INSERT INTO Film VALUES ('All About Eve', 'Drama', 138, 'NOT RATED', '1950');
  141. INSERT INTO Film VALUES ('Yojimbo', 'Action, Drama, Thriller', 110, 'NOT RATED', '1961');
  142. INSERT INTO Film VALUES ('Up', 'Animation, Adventure, Comedy', 96, 'PG', '2009');
  143. INSERT INTO Film VALUES ('Batman Begins', 'Action, Adventure, Thriller', 140, 'PG-13', '2005');
  144. INSERT INTO Film VALUES ('Some Like It Hot', 'Comedy, Romance', 121, 'NOT RATED', '1959');
  145. INSERT INTO Film VALUES ('The Treasure of the Sierra Madre', 'Adventure, Drama, Western', 126, 'NOT RATED', '1948');
  146. INSERT INTO Film VALUES ('Unforgiven', 'Drama, Western', 130, 'R', '1992');
  147. INSERT INTO Film VALUES ('Downfall', 'Biography, Drama, History', 156, 'R', '2004');
  148. INSERT INTO Film VALUES ('Die Hard', 'Action, Thriller', 132, 'R', '1988');
  149. INSERT INTO Film VALUES ('Raging Bull', 'Biography, Drama, Sport', 129, 'R', '1980');
  150. INSERT INTO Film VALUES ('Heat', 'Action, Crime, Drama', 170, 'R', '1995');
  151. INSERT INTO Film VALUES ('Children of Heaven', 'Drama, Family', 89, 'PG', '1997');
  152. INSERT INTO Film VALUES ('The Third Man', 'Film-Noir, Mystery, Thriller', 93, 'NOT RATED', '1949');
  153. INSERT INTO Film VALUES ('The Great Escape', 'Adventure, Drama, History', 172, 'NOT RATED', '1963');
  154. INSERT INTO Film VALUES ('Ikiru', 'Drama', 143, 'NOT RATED', '1952');
  155. INSERT INTO Film VALUES ('Chinatown', 'Drama, Mystery, Thriller', 130, 'R', '1974');
  156. INSERT INTO Film VALUES ('Pan''s Labyrinth', 'Drama, Fantasy, War', 118, 'R', '2006');
  157. INSERT INTO Film VALUES ('My Neighbor Totoro', 'Animation, Family, Fantasy', 86, 'G', '1988');
  158. INSERT INTO Film VALUES ('Dunkirk', 'Action, Drama, History', 106, 'PG-13', '2017');
  159. INSERT INTO Film VALUES ('Incendies', 'Drama, Mystery, War', 131, 'R', '2010');
  160. INSERT INTO Film VALUES ('Ran', 'Action, Drama', 162, 'R', '1985');
  161. INSERT INTO Film VALUES ('Judgment at Nuremberg', 'Drama, War', 186, 'NOT RATED', '1961');
  162. INSERT INTO Film VALUES ('The Gold Rush', 'Adventure, Comedy, Drama', 95, 'NOT RATED', '1925');
  163. INSERT INTO Film VALUES ('The Secret in Their Eyes', 'Drama, Mystery, Romance', 129, 'R', '2009');
  164. INSERT INTO Film VALUES ('Howl''s Moving Castle', 'Animation, Adventure, Family', 119, 'PG', '2004');
  165. INSERT INTO Film VALUES ('Inside Out', 'Animation, Adventure, Comedy', 95, 'PG', '2015');
  166. INSERT INTO Film VALUES ('On the Waterfront', 'Crime, Drama, Thriller', 108, 'NOT RATED', '1954');
  167. INSERT INTO Film VALUES ('The Bridge on the River Kwai', 'Adventure, Drama, War', 161, 'PG', '1957');
  168. INSERT INTO Film VALUES ('The Seventh Seal', 'Drama, Fantasy', 96, 'NOT RATED', '1957');
  169. INSERT INTO Film VALUES ('Room', 'Drama', 118, 'R', '2015');
  170. INSERT INTO Film VALUES ('Lock, Stock and Two Smoking Barrels', 'Comedy, Crime', 107, 'R', '1998');
  171. INSERT INTO Film VALUES ('Mr. Smith Goes to Washington', 'Comedy, Drama', 129, 'NOT RATED', '1939');
  172. INSERT INTO Film VALUES ('A Beautiful Mind', 'Biography, Drama', 135, 'PG-13', '2001');
  173. INSERT INTO Film VALUES ('Casino', 'Crime, Drama', 178, 'R', '1995');
  174. INSERT INTO Film VALUES ('Blade Runner', 'Sci-Fi, Thriller', 117, 'R', '1982');
  175. INSERT INTO Film VALUES ('The Elephant Man', 'Biography, Drama', 124, 'PG', '1980');
  176. INSERT INTO Film VALUES ('V for Vendetta', 'Action, Drama, Sci-Fi', 132, 'R', '2005');
  177. INSERT INTO Film VALUES ('Wild Strawberries', 'Drama, Romance', 91, 'NOT RATED', '1957');
  178. INSERT INTO Film VALUES ('The Wolf of Wall Street', 'Biography, Comedy, Crime', 180, 'R', '2013');
  179. INSERT INTO Film VALUES ('The General', 'Action, Adventure, Comedy', 67, 'NOT RATED', '1926');
  180. INSERT INTO Film VALUES ('Warrior', 'Drama, Sport', 140, 'PG-13', '2011');
  181. INSERT INTO Film VALUES ('Dial M for Murder', 'Crime, Film-Noir, Thriller', 105, 'PG', '1954');
  182. INSERT INTO Film VALUES ('Trainspotting', 'Drama', 94, 'R', '1996');
  183. INSERT INTO Film VALUES ('Gran Torino', 'Drama', 116, 'R', '2008');
  184. INSERT INTO Film VALUES ('Gone with the Wind', 'Drama, History, Romance', 238, 'G', '1939');
  185. INSERT INTO Film VALUES ('The Deer Hunter', 'Drama, War', 183, 'R', '1978');
  186. INSERT INTO Film VALUES ('Sunrise', 'Drama, Romance', 94, 'NOT RATED', '1927');
  187. INSERT INTO Film VALUES ('The Sixth Sense', 'Drama, Mystery, Thriller', 107, 'PG-13', '1999');
  188. INSERT INTO Film VALUES ('Fargo', 'Crime, Drama, Thriller', 98, 'R', '1996');
  189. INSERT INTO Film VALUES ('No Country for Old Men', 'Crime, Drama, Thriller', 122, 'R', '2007');
  190. INSERT INTO Film VALUES ('The Thing', 'Horror, Mystery, Sci-Fi', 109, 'R', '1982');
  191. INSERT INTO Film VALUES ('Andrei Rublev', 'Biography, Drama, History', 205, 'NOT RATED', '1966');
  192. INSERT INTO Film VALUES ('The Big Lebowski', 'Comedy, Crime', 117, 'R', '1998');
  193. INSERT INTO Film VALUES ('Finding Nemo', 'Animation, Adventure, Comedy', 100, 'G', '2003');
  194. INSERT INTO Film VALUES ('Tokyo Story', 'Drama', 136, 'NOT RATED', '1953');
  195. INSERT INTO Film VALUES ('There Will Be Blood', 'Drama, History', 158, 'R', '2007');
  196. INSERT INTO Film VALUES ('Cool Hand Luke', 'Crime, Drama', 126, 'GP', '1967');
  197. INSERT INTO Film VALUES ('Come and See', 'Drama, War', 142, 'NOT RATED', '1985');
  198. INSERT INTO Film VALUES ('Rebecca', 'Drama, Mystery, Romance', 130, 'NOT RATED', '1940');
  199. INSERT INTO Film VALUES ('Hacksaw Ridge', 'Biography, Drama, History', 139, 'R', '2016');
  200. INSERT INTO Film VALUES ('Kill Bill: Vol. 1', 'Action, Crime, Thriller', 111, 'R', '2003');
  201. INSERT INTO Film VALUES ('How to Train Your Dragon', 'Animation, Adventure, Comedy', 98, 'PG', '2010');
  202. INSERT INTO Film VALUES ('Rang De Basanti', 'Comedy, Drama, History', 157, 'NOT RATED', '2006');
  203. INSERT INTO Film VALUES ('Mary and Max', 'Animation, Comedy, Drama', 92, 'NOT RATED', '2009');
  204. INSERT INTO Film VALUES ('Gone Girl', 'Crime, Drama, Mystery', 149, 'R', '2014');
  205. INSERT INTO Film VALUES ('The Passion of Joan of Arc', 'Biography, Drama, History', 114, 'NOT RATED', '1928');
  206. INSERT INTO Film VALUES ('Shutter Island', 'Mystery, Thriller', 138, 'R', '2010');
  207. INSERT INTO Film VALUES ('Into the Wild', 'Adventure, Biography, Drama', 148, 'R', '2007');
  208. INSERT INTO Film VALUES ('La La Land', 'Comedy, Drama, Music', 128, 'PG-13', '2016');
  209. INSERT INTO Film VALUES ('Life of Brian', 'Comedy', 94, 'R', '1979');
  210. INSERT INTO Film VALUES ('It Happened One Night', 'Comedy, Romance', 105, 'NOT RATED', '1934');
  211. INSERT INTO Film VALUES ('Relatos salvajes', 'Comedy, Drama, Thriller', 122, 'R', '2014');
  212. INSERT INTO Film VALUES ('Logan', 'Action, Drama, Sci-Fi', 137, 'R', '2017');
  213. INSERT INTO Film VALUES ('Platoon', 'Drama, War', 120, 'R', '1986');
  214. INSERT INTO Film VALUES ('Hotel Rwanda', 'Biography, Drama, History', 121, 'PG-13', '2004');
  215. INSERT INTO Film VALUES ('The Wages of Fear', 'Adventure, Drama, Thriller', 131, 'NOT RATED', '1953');
  216. INSERT INTO Film VALUES ('Network', 'Drama', 121, 'R', '1976');
  217. INSERT INTO Film VALUES ('In the Name of the Father', 'Biography, Drama', 133, 'R', '1993');
  218. INSERT INTO Film VALUES ('Stand by Me', 'Adventure, Drama', 89, 'R', '1986');
  219. INSERT INTO Film VALUES ('Rush', 'Action, Biography, Drama', 123, 'R', '2013');
  220. INSERT INTO Film VALUES ('A Wednesday', 'Crime, Drama, Mystery', 104, 'NOT RATED', '2008');
  221. INSERT INTO Film VALUES ('Persona', 'Drama, Thriller', 83, 'NOT RATED', '1966');
  222. INSERT INTO Film VALUES ('Ben-Hur', 'Adventure, Drama, History', 212, 'G', '1959');
  223. INSERT INTO Film VALUES ('The Grand Budapest Hotel', 'Adventure, Comedy, Drama', 99, 'R', '2014');
  224. INSERT INTO Film VALUES ('The 400 Blows', 'Crime, Drama', 99, 'NOT RATED', '1959');
  225. INSERT INTO Film VALUES ('Jurassic Park', 'Adventure, Sci-Fi, Thriller', 127, 'PG-13', '1993');
  226. INSERT INTO Film VALUES ('Memories of Murder', 'Action, Crime, Drama', 132, 'NOT RATED', '2003');
  227. INSERT INTO Film VALUES ('12 Years a Slave', 'Biography, Drama, History', 134, 'R', '2013');
  228. INSERT INTO Film VALUES ('Mad Max: Fury Road', 'Action, Adventure, Sci-Fi', 120, 'R', '2015');
  229. INSERT INTO Film VALUES ('Million Dollar Baby', 'Drama, Sport', 132, 'PG-13', '2004');
  230. INSERT INTO Film VALUES ('Thor: Ragnarok', 'Action, Adventure, Comedy', 130, 'PG-13', '2017');
  231. INSERT INTO Film VALUES ('Spotlight', 'Crime, Drama, History', 128, 'R', '2015');
  232. INSERT INTO Film VALUES ('Stalker', 'Drama, Sci-Fi', 162, 'NOT RATED', '1979');
  233. INSERT INTO Film VALUES ('The Truman Show', 'Comedy, Drama, Sci-Fi', 103, 'PG', '1998');
  234. INSERT INTO Film VALUES ('Amores Perros', 'Drama, Thriller', 154, 'R', '2000');
  235. INSERT INTO Film VALUES ('Butch Cassidy and the Sundance Kid', 'Biography, Crime, Drama', 110, 'PG', '1969');
  236. INSERT INTO Film VALUES ('Hachi: A Dog''s Tale', 'Drama, Family', 93, 'G', '2009');
  237. INSERT INTO Film VALUES ('Nausicaä of the Valley of the Wind', 'Animation, Adventure, Fantasy', 117, 'PG', '1984');
  238. INSERT INTO Film VALUES ('Before Sunrise', 'Drama, Romance', 101, 'R', '1995');
  239. INSERT INTO Film VALUES ('The Princess Bride', 'Adventure, Family, Fantasy', 98, 'PG', '1987');
  240. INSERT INTO Film VALUES ('The Maltese Falcon', 'Film-Noir, Mystery', 100, 'NOT RATED', '1941');
  241. INSERT INTO Film VALUES ('Prisoners', 'Crime, Drama, Mystery', 153, 'R', '2013');
  242. INSERT INTO Film VALUES ('Paper Moon', 'Comedy, Crime, Drama', 102, 'PG', '1973');
  243. INSERT INTO Film VALUES ('The Nights of Cabiria', 'Drama', 110, 'NOT RATED', '1957');
  244. INSERT INTO Film VALUES ('Harry Potter and the Deathly Hallows: Part 2', 'Adventure, Drama, Fantasy', 130, 'PG-13', '2011');
  245. INSERT INTO Film VALUES ('Catch Me If You Can', 'Biography, Crime, Drama', 141, 'PG-13', '2002');
  246. INSERT INTO Film VALUES ('Rocky', 'Drama, Sport', 120, 'PG', '1976');
  247. INSERT INTO Film VALUES ('The Grapes of Wrath', 'Drama, History', 129, 'NOT RATED', '1940');
  248. INSERT INTO Film VALUES ('Diabolique', 'Crime, Drama, Horror', 117, 'NOT RATED', '1955');
  249. INSERT INTO Film VALUES ('Touch of Evil', 'Crime, Drama, Film-Noir', 95, 'PG-13', '1958');
  250. INSERT INTO Film VALUES ('Monsters, Inc.', 'Animation, Adventure, Comedy', 92, 'G', '2001');
  251. INSERT INTO Film VALUES ('Gandhi', 'Biography, Drama, History', 191, 'PG', '1982');
  252. INSERT INTO Film VALUES ('Donnie Darko', 'Drama, Sci-Fi, Thriller', 113, 'R', '2001');
  253. INSERT INTO Film VALUES ('Barry Lyndon', 'Adventure, Drama, History', 185, 'PG', '1975');
  254. INSERT INTO Film VALUES ('Annie Hall', 'Comedy, Romance', 93, 'PG', '1977');
  255. INSERT INTO Film VALUES ('The Terminator', 'Action, Sci-Fi', 107, 'R', '1984');
  256. INSERT INTO Film VALUES ('The Bourne Ultimatum', 'Action, Mystery, Thriller', 115, 'PG-13', '2007');
  257. INSERT INTO Film VALUES ('The Wizard of Oz', 'Adventure, Family, Fantasy', 102, 'PG', '1939');
  258. INSERT INTO Film VALUES ('Groundhog Day', 'Comedy, Fantasy, Romance', 101, 'PG', '1993');
  259. INSERT INTO Film VALUES ('La Haine', 'Crime, Drama', 98, 'NOT RATED', '1995');
  260. INSERT INTO Film VALUES ('8½', 'Drama', 138, 'NOT RATED', '1963');
  261. INSERT INTO Film VALUES ('Munna Bhai M.B.B.S.', 'Comedy, Drama, Romance', 156, 'NOT RATED', '2003');
  262. INSERT INTO Film VALUES ('Star Wars: The Force Awakens', 'Action, Adventure, Fantasy', 136, 'PG-13', '2015');
  263. INSERT INTO Film VALUES ('Jaws', 'Adventure, Drama, Thriller', 124, 'PG', '1975');
  264. INSERT INTO Film VALUES ('The Best Years of Our Lives', 'Drama, Romance, War', 170, 'NOT RATED', '1946');
  265. INSERT INTO Film VALUES ('Twelve Monkeys', 'Mystery, Sci-Fi, Thriller', 129, 'R', '1995');
  266. INSERT INTO Film VALUES ('Infernal Affairs', 'Crime, Drama, Mystery', 101, 'R', '2002');
  267. INSERT INTO Film VALUES ('In the Mood for Love', 'Drama, Romance', 98, 'PG', '2000');
  268. INSERT INTO Film VALUES ('Paris, Texas', 'Drama', 145, 'R', '1984');
  269. INSERT INTO Film VALUES ('The Help', 'Drama', 146, 'PG-13', '2011');
  270. INSERT INTO Film VALUES ('Dead Poets Society', 'Comedy, Drama', 128, 'PG', '1989');
  271. INSERT INTO Film VALUES ('Beauty and the Beast', 'Animation, Family, Fantasy', 84, 'G', '1991');
  272. INSERT INTO Film VALUES ('Ah-ga-ssi', 'Crime, Drama, Mystery', 144, 'NOT RATED', '2016');
  273. INSERT INTO Film VALUES ('Dog Day Afternoon', 'Biography, Crime, Drama', 125, 'R', '1975');
  274. INSERT INTO Film VALUES ('Pirates of the Caribbean: The Curse of the Black Pearl', 'Action, Adventure, Fantasy', 143, 'PG-13', '2003');
  275.  
  276. CREATE TABLE Human (login VARCHAR(200) NOT NULL, name VARCHAR(200) NOT NULL, birthdate DATE);
  277. ALTER TABLE dbo.Human ADD ID INT IDENTITY;
  278. ALTER TABLE dbo.Human ADD CONSTRAINT PK_Human PRIMARY KEY(ID);
  279.  
  280. INSERT INTO Human VALUES ('mirth_1973_76947', 'Larae Gilbert', '1973.06.28');
  281. INSERT INTO Human VALUES ('Plimsol.1980_84576', 'Jackqueline Combs', '1980.07.13');
  282. INSERT INTO Human VALUES ('chameleons-2008_58036', 'Ja Hanson', '2008.10.02');
  283. INSERT INTO Human VALUES ('biteme-1971_98603', 'Joline Rowe', '1971.01.13');
  284. INSERT INTO Human VALUES ('Explains-1988_46459', 'Josef Solis', '1988.02.16');
  285. INSERT INTO Human VALUES ('embark.1972_17383', 'Yuette Pate', '1972.07.04');
  286. INSERT INTO Human VALUES ('Arnone.1995_76092', 'Jesenia Vasquez', '1995.03.01');
  287. INSERT INTO Human VALUES ('Delly_1995_46223', 'Hien Spears', '1995.05.11');
  288. INSERT INTO Human VALUES ('Tilak1972_51930', 'Denita Mccullough', '1972.04.11');
  289. INSERT INTO Human VALUES ('Analogue-1981_98211', 'Dominick Pugh', '1981.03.19');
  290. INSERT INTO Human VALUES ('Capelet_1989_34578', 'Marvin Frost', '1989.09.05');
  291. INSERT INTO Human VALUES ('Artemis_2008_39370', 'Lemuel Pugh', '2008.12.21');
  292. INSERT INTO Human VALUES ('Beaucoup-2007_11843', 'Coy Farley', '2007.11.17');
  293. INSERT INTO Human VALUES ('inspector_1984_86277', 'Josphine Atkins', '1984.04.25');
  294. INSERT INTO Human VALUES ('Herbivore.1996_66184', 'Fermin Wise', '1996.08.25');
  295. INSERT INTO Human VALUES ('denny.1977_98130', 'Jadwiga Gomez', '1977.11.17');
  296. INSERT INTO Human VALUES ('Decking-1994_74971', 'Colene Meyers', '1994.04.23');
  297. INSERT INTO Human VALUES ('Voyageurs1990_77327', 'Dell Hodges', '1990.05.07');
  298. INSERT INTO Human VALUES ('Divus1987_17356', 'Gita Castaneda', '1987.05.11');
  299. INSERT INTO Human VALUES ('Argonaut1981_41011', 'Lance Blackburn', '1981.12.23');
  300. INSERT INTO Human VALUES ('booking1996_92103', 'Son Callahan', '1996.04.14');
  301. INSERT INTO Human VALUES ('Peroxid2000_45340', 'Lynelle Walsh', '2000.01.14');
  302. INSERT INTO Human VALUES ('Abdominal_1996_67430', 'Arlean Holcomb', '1996.09.19');
  303. INSERT INTO Human VALUES ('scheme_2002_29865', 'Caleb Griffith', '2002.04.23');
  304. INSERT INTO Human VALUES ('crusty1979_39135', 'Simon Mcintyre', '1979.01.22');
  305. INSERT INTO Human VALUES ('evened.1972_97089', 'Teresia Bird', '1972.07.16');
  306. INSERT INTO Human VALUES ('bares1988_05676', 'Renaldo Velez', '1988.09.04');
  307. INSERT INTO Human VALUES ('Snowdrops_1981_98554', 'Cecil Ayala', '1981.12.27');
  308. INSERT INTO Human VALUES ('aplysia-1998_44775', 'Boyce Ball', '1998.03.22');
  309. INSERT INTO Human VALUES ('craney.1978_79225', 'Forest Fields', '1978.12.06');
  310. INSERT INTO Human VALUES ('Peery1988_41881', 'Antonio Mills', '1988.02.03');
  311. INSERT INTO Human VALUES ('Rooky_1970_06446', 'Ngan Lawrence', '1970.03.13');
  312. INSERT INTO Human VALUES ('agamic_2007_90992', 'Charles Charles', '2007.07.03');
  313. INSERT INTO Human VALUES ('Falchion1972_62881', 'Elisha Pittman', '1972.06.22');
  314. INSERT INTO Human VALUES ('dogie_2010_43273', 'Britany Gallagher', '2010.06.26');
  315. INSERT INTO Human VALUES ('beresfor.1984_42154', 'Lamont Franco', '1984.02.09');
  316. INSERT INTO Human VALUES ('Eyelashes_1974_78608', 'Ellis Dorsey', '1974.09.14');
  317. INSERT INTO Human VALUES ('prisons1985_93028', 'Maynard Walters', '1985.11.17');
  318. INSERT INTO Human VALUES ('masterstroke.1987_17521', 'Colene Madden', '1987.10.27');
  319. INSERT INTO Human VALUES ('Deutzia1987_83050', 'Jordon Woodward', '1987.02.19');
  320. INSERT INTO Human VALUES ('Saltish.1998_95306', 'Rolande Mcfadden', '1998.09.17');
  321. INSERT INTO Human VALUES ('agathodaemon_2001_25709', 'Louetta Blankenship', '2001.07.13');
  322. INSERT INTO Human VALUES ('unaccountably1986_11266', 'Maynard Carlson', '1986.11.19');
  323. INSERT INTO Human VALUES ('Eller_2000_22013', 'Burt Ryan', '2000.09.19');
  324. INSERT INTO Human VALUES ('Thanking_1988_19864', 'Jordon Bridges', '1988.08.24');
  325. INSERT INTO Human VALUES ('Novelette_2010_27534', 'Darrin Love', '2010.07.10');
  326. INSERT INTO Human VALUES ('Chaotic_1973_74885', 'Randolph Gutierrez', '1973.09.26');
  327. INSERT INTO Human VALUES ('confused-1977_43976', 'Neida Mann', '1977.09.01');
  328. INSERT INTO Human VALUES ('Azuma_1979_68907', 'Susann Dennis', '1979.02.17');
  329. INSERT INTO Human VALUES ('camber-1989_83368', 'Euna Dorsey', '1989.10.18');
  330. INSERT INTO Human VALUES ('Diwata.1996_31593', 'Simon Shields', '1996.08.07');
  331. INSERT INTO Human VALUES ('autogiro1971_38311', 'Jesus Maxwell', '1971.01.12');
  332. INSERT INTO Human VALUES ('systemic2004_49304', 'Donetta Frazier', '2004.07.11');
  333. INSERT INTO Human VALUES ('Acree.1982_57252', 'Alonso Whitehead', '1982.10.05');
  334. INSERT INTO Human VALUES ('capelet1985_67843', 'Herbert Ware', '1985.03.02');
  335. INSERT INTO Human VALUES ('berri1981_79670', 'Tilda Bryan', '1981.05.03');
  336. INSERT INTO Human VALUES ('Behead_1984_68703', 'Bret Bolton', '1984.10.04');
  337. INSERT INTO Human VALUES ('pommies-1999_56017', 'Tammera Saunders', '1999.02.14');
  338. INSERT INTO Human VALUES ('Biker-1982_94513', 'Jeanmarie Leonard', '1982.12.26');
  339. INSERT INTO Human VALUES ('Arteries-2000_57864', 'Emerson Clay', '2000.12.26');
  340. INSERT INTO Human VALUES ('Bourguig.1977_47091', 'Jaye Melendez', '1977.03.06');
  341. INSERT INTO Human VALUES ('Snarling_2007_28684', 'Antonio Joyce', '2007.06.12');
  342. INSERT INTO Human VALUES ('elsey.1970_60101', 'Vella Mcclure', '1970.04.30');
  343. INSERT INTO Human VALUES ('cinque_1999_72576', 'Margy Levine', '1999.08.17');
  344. INSERT INTO Human VALUES ('ennead1977_92429', 'Burl Knox', '1977.10.28');
  345. INSERT INTO Human VALUES ('deckers1994_72283', 'Daryl Carey', '1994.11.01');
  346. INSERT INTO Human VALUES ('Anime1992_82892', 'Loyce Brady', '1992.11.04');
  347. INSERT INTO Human VALUES ('Celebrity.1974_64224', 'Tesha Fleming', '1974.08.06');
  348. INSERT INTO Human VALUES ('Broomer-1973_09656', 'Jerrod Boone', '1973.11.02');
  349. INSERT INTO Human VALUES ('divus_1991_18143', 'Merissa Thornton', '1991.03.12');
  350. INSERT INTO Human VALUES ('dingar_1997_69806', 'Genevie Potter', '1997.12.10');
  351. INSERT INTO Human VALUES ('Wallet-1977_98843', 'Dennis Harris', '1977.09.11');
  352. INSERT INTO Human VALUES ('Anastasia1979_22440', 'Phung Simon', '1979.11.01');
  353. INSERT INTO Human VALUES ('Donica1984_08336', 'Alysa Pacheco', '1984.09.27');
  354. INSERT INTO Human VALUES ('Bubales-2006_16727', 'Emilio Chang', '2006.08.20');
  355. INSERT INTO Human VALUES ('cimex2001_94689', 'Dede Contreras', '2001.08.24');
  356. INSERT INTO Human VALUES ('Contemptuous2009_08638', 'Shayne Lynch', '2009.05.30');
  357. INSERT INTO Human VALUES ('thrush1977_18514', 'Truman Vinson', '1977.08.09');
  358. INSERT INTO Human VALUES ('battles-1974_90155', 'Emile Cortez', '1974.11.19');
  359. INSERT INTO Human VALUES ('aqueduct_1976_57383', 'Grady England', '1976.04.09');
  360. INSERT INTO Human VALUES ('buckeye_1996_25348', 'Kimbra Guthrie', '1996.10.14');
  361. INSERT INTO Human VALUES ('Epicentral1989_12325', 'Twanna Valenzuela', '1989.10.26');
  362. INSERT INTO Human VALUES ('worker-2001_71058', 'Son Barker', '2001.11.18');
  363. INSERT INTO Human VALUES ('backcross_1983_50899', 'Joya Paul', '1983.10.09');
  364. INSERT INTO Human VALUES ('airplay2001_14925', 'Billye Castillo', '2001.10.29');
  365. INSERT INTO Human VALUES ('Surrey.1991_62858', 'Shawn Baxter', '1991.04.21');
  366. INSERT INTO Human VALUES ('alligators-1971_46409', 'Onie Mendoza', '1971.11.22');
  367. INSERT INTO Human VALUES ('vegan_1975_25723', 'Herta Morris', '1975.07.14');
  368. INSERT INTO Human VALUES ('paseos_1980_00794', 'Tiesha Herring', '1980.08.24');
  369. INSERT INTO Human VALUES ('asbest-1993_92336', 'Joaquin Wilcox', '1993.08.21');
  370. INSERT INTO Human VALUES ('fiction1996_51750', 'Arie Clayton', '1996.09.16');
  371. INSERT INTO Human VALUES ('dayman-1996_98387', 'Mitsuko Ward', '1996.06.28');
  372. INSERT INTO Human VALUES ('Esurience_2001_55486', 'Yuko Rice', '2001.07.19');
  373. INSERT INTO Human VALUES ('capriole_1979_24650', 'Ernie Mclean', '1979.08.11');
  374. INSERT INTO Human VALUES ('dosers_1988_27932', 'Duane Wooten', '1988.01.31');
  375. INSERT INTO Human VALUES ('shakable2000_66519', 'Angel Sloan', '2000.02.23');
  376. INSERT INTO Human VALUES ('augeri1987_90751', 'Norman Rodgers', '1987.07.17');
  377. INSERT INTO Human VALUES ('scoot-1995_40490', 'Erin Quinn', '1995.07.21');
  378. INSERT INTO Human VALUES ('Failsafe-1993_28280', 'Donnette Cook', '1993.05.13');
  379. INSERT INTO Human VALUES ('Ceibo_2004_30737', 'Shavon Ware', '2004.04.10');
  380.  
  381. CREATE TABLE Session (sessionDate DATE NOT NULL, sessionTime TIME NOT NULL, cinemaId INT FOREIGN KEY REFERENCES Cinema(id) NOT NULL, filmId INT FOREIGN KEY REFERENCES Film(id) NOT NULL, price MONEY);
  382. ALTER TABLE dbo.Session ADD ID INT IDENTITY;
  383. ALTER TABLE dbo.Session ADD CONSTRAINT PK_Session PRIMARY KEY(ID);
  384.  
  385. INSERT INTO Session VALUES ('2015-12-30', '00:02:28', 18, 21, 5876.51)
  386. INSERT INTO Session VALUES ('2016-11-14', '18:37:16', 8, 14, 9201.83)
  387. INSERT INTO Session VALUES ('2010-09-22', '13:56:34', 4, 11, 5653.48)
  388. INSERT INTO Session VALUES ('2014-01-03', '23:11:51', 10, 14, 5993.22)
  389. INSERT INTO Session VALUES ('2014-12-10', '11:21:08', 3, 17, 5867.92)
  390. INSERT INTO Session VALUES ('2010-03-13', '15:45:39', 6, 15, 9741.41)
  391. INSERT INTO Session VALUES ('2015-02-04', '09:40:07', 18, 3, 3057.05)
  392. INSERT INTO Session VALUES ('2014-06-15', '07:25:51', 9, 1, 2926.79)
  393. INSERT INTO Session VALUES ('2013-04-27', '06:32:52', 18, 1, 7237.07)
  394. INSERT INTO Session VALUES ('2015-03-13', '01:42:27', 14, 22, 9267.04)
  395. INSERT INTO Session VALUES ('2011-07-09', '05:20:05', 1, 7, 4212.89)
  396. INSERT INTO Session VALUES ('2014-08-17', '04:13:04', 1, 16, 5087.64)
  397. INSERT INTO Session VALUES ('2016-07-09', '13:20:24', 5, 5, 4173.93)
  398. INSERT INTO Session VALUES ('2016-06-08', '19:31:02', 8, 15, 3322.15)
  399. INSERT INTO Session VALUES ('2016-09-14', '17:16:10', 6, 26, 5100.33)
  400. INSERT INTO Session VALUES ('2017-01-14', '12:36:57', 6, 19, 7533.77)
  401. INSERT INTO Session VALUES ('2011-11-23', '16:00:04', 5, 5, 8344.47)
  402. INSERT INTO Session VALUES ('2017-05-14', '20:38:31', 12, 21, 1560.8)
  403. INSERT INTO Session VALUES ('2010-05-05', '13:50:11', 1, 35, 6913.41)
  404. INSERT INTO Session VALUES ('2017-09-25', '05:16:09', 17, 8, 1779.91)
  405. INSERT INTO Session VALUES ('2017-04-18', '06:33:25', 3, 2, 1312.98)
  406. INSERT INTO Session VALUES ('2011-11-07', '18:06:06', 14, 37, 4830.71)
  407. INSERT INTO Session VALUES ('2012-10-06', '21:23:28', 9, 23, 3656.16)
  408. INSERT INTO Session VALUES ('2011-01-31', '08:49:40', 17, 37, 2536.44)
  409. INSERT INTO Session VALUES ('2016-03-30', '01:52:24', 5, 26, 3090.65)
  410. INSERT INTO Session VALUES ('2015-08-30', '22:12:38', 10, 21, 1481.93)
  411. INSERT INTO Session VALUES ('2012-09-24', '18:14:37', 13, 20, 9443.3)
  412. INSERT INTO Session VALUES ('2010-01-28', '09:17:17', 16, 9, 7867.97)
  413. INSERT INTO Session VALUES ('2017-10-13', '04:18:10', 7, 15, 1155.89)
  414. INSERT INTO Session VALUES ('2010-07-15', '14:11:26', 4, 23, 9108.93)
  415. INSERT INTO Session VALUES ('2017-07-09', '00:37:43', 5, 17, 9375.6)
  416. INSERT INTO Session VALUES ('2012-10-02', '06:38:34', 18, 5, 7817.07)
  417. INSERT INTO Session VALUES ('2014-12-14', '21:38:07', 11, 23, 8906.1)
  418. INSERT INTO Session VALUES ('2017-01-08', '07:27:00', 13, 14, 7413.64)
  419. INSERT INTO Session VALUES ('2017-11-06', '07:57:48', 18, 21, 9379.87)
  420. INSERT INTO Session VALUES ('2017-09-23', '12:50:20', 4, 37, 6348.2)
  421. INSERT INTO Session VALUES ('2014-07-02', '19:29:24', 1, 39, 7850.17)
  422. INSERT INTO Session VALUES ('2010-08-25', '03:08:27', 17, 6, 7395.3)
  423. INSERT INTO Session VALUES ('2015-01-07', '11:27:39', 8, 39, 688.28)
  424. INSERT INTO Session VALUES ('2011-07-08', '11:13:16', 7, 40, 6565.51)
  425. INSERT INTO Session VALUES ('2011-02-16', '11:11:09', 8, 40, 2236.38)
  426. INSERT INTO Session VALUES ('2014-08-07', '05:05:50', 13, 2, 6703.0)
  427. INSERT INTO Session VALUES ('2012-01-18', '06:56:52', 5, 22, 9208.51)
  428. INSERT INTO Session VALUES ('2012-11-19', '02:45:24', 9, 21, 8088.82)
  429. INSERT INTO Session VALUES ('2010-07-05', '01:22:58', 7, 5, 8919.42)
  430. INSERT INTO Session VALUES ('2015-02-09', '03:47:25', 1, 40, 1552.38)
  431. INSERT INTO Session VALUES ('2016-03-29', '07:49:07', 9, 16, 6564.81)
  432. INSERT INTO Session VALUES ('2012-07-29', '11:07:15', 1, 19, 9592.45)
  433. INSERT INTO Session VALUES ('2014-11-03', '09:49:54', 15, 39, 6265.26)
  434. INSERT INTO Session VALUES ('2014-12-08', '23:50:38', 16, 1, 1371.8)
  435. INSERT INTO Session VALUES ('2011-12-08', '21:49:34', 8, 16, 4930.13)
  436. INSERT INTO Session VALUES ('2016-10-21', '02:37:07', 15, 28, 9982.81)
  437. INSERT INTO Session VALUES ('2015-01-17', '05:00:31', 8, 36, 3506.96)
  438. INSERT INTO Session VALUES ('2010-06-20', '06:07:10', 2, 34, 6894.44)
  439. INSERT INTO Session VALUES ('2014-01-09', '01:06:42', 17, 17, 1144.66)
  440. INSERT INTO Session VALUES ('2011-01-29', '06:27:04', 17, 7, 4632.24)
  441. INSERT INTO Session VALUES ('2013-02-27', '18:28:31', 5, 11, 1174.5)
  442. INSERT INTO Session VALUES ('2011-02-09', '02:58:12', 4, 27, 5332.26)
  443. INSERT INTO Session VALUES ('2014-07-05', '07:43:31', 5, 40, 8443.5)
  444. INSERT INTO Session VALUES ('2017-08-16', '20:03:47', 7, 8, 6699.07)
  445. INSERT INTO Session VALUES ('2014-06-13', '15:16:04', 15, 9, 2584.42)
  446. INSERT INTO Session VALUES ('2011-05-19', '08:33:46', 13, 22, 4097.7)
  447. INSERT INTO Session VALUES ('2013-12-18', '16:43:35', 14, 7, 5091.6)
  448. INSERT INTO Session VALUES ('2014-10-17', '16:18:41', 8, 18, 2429.58)
  449. INSERT INTO Session VALUES ('2016-09-11', '08:41:26', 8, 11, 9133.51)
  450. INSERT INTO Session VALUES ('2017-03-19', '11:17:31', 11, 31, 2674.06)
  451. INSERT INTO Session VALUES ('2012-10-03', '17:57:54', 11, 40, 2200.39)
  452. INSERT INTO Session VALUES ('2014-11-18', '16:03:13', 9, 31, 2948.38)
  453. INSERT INTO Session VALUES ('2010-05-23', '05:14:30', 16, 31, 9781.96)
  454. INSERT INTO Session VALUES ('2017-05-08', '18:00:22', 2, 28, 631.9)
  455. INSERT INTO Session VALUES ('2016-05-13', '03:49:09', 7, 16, 821.54)
  456. INSERT INTO Session VALUES ('2014-09-05', '21:40:18', 12, 23, 517.66)
  457. INSERT INTO Session VALUES ('2013-09-06', '16:04:03', 8, 18, 1789.26)
  458. INSERT INTO Session VALUES ('2017-12-30', '21:50:05', 2, 39, 7266.26)
  459. INSERT INTO Session VALUES ('2010-10-25', '17:10:41', 2, 13, 3022.14)
  460. INSERT INTO Session VALUES ('2014-06-07', '16:45:49', 1, 7, 3628.45)
  461. INSERT INTO Session VALUES ('2011-04-25', '16:38:15', 3, 12, 3745.36)
  462. INSERT INTO Session VALUES ('2017-10-12', '19:58:48', 17, 36, 1508.93)
  463. INSERT INTO Session VALUES ('2017-02-19', '06:11:28', 1, 4, 2984.3)
  464. INSERT INTO Session VALUES ('2017-03-19', '12:10:50', 13, 16, 5955.07)
  465. INSERT INTO Session VALUES ('2010-01-27', '15:35:26', 4, 21, 9954.47)
  466. INSERT INTO Session VALUES ('2016-01-04', '02:22:21', 1, 16, 6236.07)
  467. INSERT INTO Session VALUES ('2010-02-11', '15:30:10', 1, 29, 5931.42)
  468. INSERT INTO Session VALUES ('2016-11-02', '23:09:28', 2, 12, 5579.23)
  469. INSERT INTO Session VALUES ('2013-08-06', '11:53:15', 8, 5, 6102.08)
  470. INSERT INTO Session VALUES ('2017-01-16', '09:21:40', 11, 28, 8451.66)
  471. INSERT INTO Session VALUES ('2011-03-18', '21:49:34', 16, 33, 1894.03)
  472. INSERT INTO Session VALUES ('2011-10-15', '05:23:24', 11, 37, 1576.28)
  473. INSERT INTO Session VALUES ('2010-05-23', '05:35:23', 11, 22, 1482.02)
  474. INSERT INTO Session VALUES ('2011-06-26', '01:59:21', 10, 24, 3185.34)
  475. INSERT INTO Session VALUES ('2013-09-27', '15:59:21', 14, 37, 794.59)
  476. INSERT INTO Session VALUES ('2017-06-26', '22:09:29', 9, 21, 152.74)
  477. INSERT INTO Session VALUES ('2015-11-05', '21:17:59', 11, 2, 2818.74)
  478. INSERT INTO Session VALUES ('2017-11-13', '09:09:55', 5, 3, 7519.67)
  479. INSERT INTO Session VALUES ('2016-06-28', '02:54:20', 11, 17, 4481.49)
  480. INSERT INTO Session VALUES ('2012-06-21', '10:25:34', 17, 17, 9024.97)
  481. INSERT INTO Session VALUES ('2012-01-02', '16:14:35', 6, 37, 3702.05)
  482. INSERT INTO Session VALUES ('2013-12-26', '20:33:10', 12, 13, 4920.85)
  483. INSERT INTO Session VALUES ('2015-01-30', '16:10:11', 14, 32, 847.32)
  484. INSERT INTO Session VALUES ('2013-03-29', '00:29:00', 7, 11, 3146.38)
  485. INSERT INTO Session VALUES ('2015-07-25', '21:26:50', 5, 23, 4280.7)
  486. INSERT INTO Session VALUES ('2011-05-27', '00:00:34', 5, 40, 2196.71)
  487. INSERT INTO Session VALUES ('2010-01-29', '20:21:19', 2, 7, 3805.37)
  488. INSERT INTO Session VALUES ('2013-06-14', '04:53:42', 7, 21, 778.13)
  489. INSERT INTO Session VALUES ('2013-10-16', '17:44:01', 3, 40, 3464.73)
  490. INSERT INTO Session VALUES ('2016-03-16', '03:34:36', 7, 6, 5252.19)
  491. INSERT INTO Session VALUES ('2010-12-01', '01:08:14', 13, 19, 1628.51)
  492. INSERT INTO Session VALUES ('2012-08-14', '22:12:19', 4, 2, 7991.61)
  493. INSERT INTO Session VALUES ('2015-10-16', '15:50:46', 18, 14, 1438.26)
  494. INSERT INTO Session VALUES ('2017-07-19', '19:27:42', 5, 16, 2654.54)
  495. INSERT INTO Session VALUES ('2011-04-25', '10:19:08', 2, 2, 7700.23)
  496. INSERT INTO Session VALUES ('2010-11-07', '05:45:32', 1, 26, 6984.81)
  497. INSERT INTO Session VALUES ('2016-09-24', '10:45:41', 5, 17, 1873.32)
  498. INSERT INTO Session VALUES ('2017-11-20', '20:55:19', 10, 33, 5181.6)
  499. INSERT INTO Session VALUES ('2013-11-23', '03:44:03', 5, 11, 6343.12)
  500. INSERT INTO Session VALUES ('2010-01-10', '12:53:29', 7, 29, 7073.24)
  501. INSERT INTO Session VALUES ('2016-03-29', '00:51:06', 7, 13, 4780.33)
  502. INSERT INTO Session VALUES ('2014-10-12', '03:11:09', 4, 34, 9485.42)
  503. INSERT INTO Session VALUES ('2016-08-30', '02:45:16', 6, 3, 4864.58)
  504. INSERT INTO Session VALUES ('2013-05-23', '09:47:14', 13, 29, 5781.92)
  505. INSERT INTO Session VALUES ('2011-10-30', '04:14:04', 3, 34, 1380.24)
  506. INSERT INTO Session VALUES ('2012-02-27', '16:50:50', 18, 27, 3358.28)
  507. INSERT INTO Session VALUES ('2014-07-18', '00:11:01', 5, 6, 8544.48)
  508. INSERT INTO Session VALUES ('2013-06-26', '20:25:02', 3, 21, 197.92)
  509. INSERT INTO Session VALUES ('2014-11-29', '04:05:51', 15, 1, 2461.24)
  510. INSERT INTO Session VALUES ('2013-05-08', '20:26:52', 1, 15, 9075.7)
  511. INSERT INTO Session VALUES ('2010-06-11', '01:34:37', 15, 39, 6297.74)
  512. INSERT INTO Session VALUES ('2013-12-09', '10:51:52', 11, 29, 2224.27)
  513. INSERT INTO Session VALUES ('2011-03-08', '05:26:02', 9, 37, 8418.99)
  514. INSERT INTO Session VALUES ('2013-07-12', '09:13:03', 12, 18, 9320.81)
  515. INSERT INTO Session VALUES ('2010-06-16', '01:42:59', 5, 23, 2887.06)
  516. INSERT INTO Session VALUES ('2015-12-04', '00:19:02', 11, 20, 8097.92)
  517. INSERT INTO Session VALUES ('2012-10-13', '16:11:48', 17, 23, 4278.09)
  518. INSERT INTO Session VALUES ('2010-10-12', '19:49:00', 1, 39, 3892.38)
  519. INSERT INTO Session VALUES ('2017-09-03', '13:29:38', 1, 26, 6626.92)
  520. INSERT INTO Session VALUES ('2012-05-27', '02:06:32', 7, 18, 4800.27)
  521. INSERT INTO Session VALUES ('2014-10-28', '11:45:56', 17, 14, 2601.23)
  522. INSERT INTO Session VALUES ('2015-06-10', '23:47:41', 3, 32, 6581.03)
  523. INSERT INTO Session VALUES ('2013-02-20', '13:03:09', 2, 11, 2274.77)
  524. INSERT INTO Session VALUES ('2010-04-13', '15:55:22', 1, 12, 2901.82)
  525. INSERT INTO Session VALUES ('2011-08-27', '09:15:45', 5, 35, 1727.23)
  526. INSERT INTO Session VALUES ('2011-06-11', '19:01:39', 11, 22, 7159.61)
  527. INSERT INTO Session VALUES ('2013-05-22', '12:51:02', 10, 21, 372.71)
  528. INSERT INTO Session VALUES ('2017-11-12', '21:55:03', 7, 4, 5000.94)
  529. INSERT INTO Session VALUES ('2011-03-25', '08:04:14', 6, 16, 5452.18)
  530. INSERT INTO Session VALUES ('2017-09-05', '05:34:59', 17, 10, 5607.49)
  531. INSERT INTO Session VALUES ('2011-12-05', '16:10:28', 17, 11, 4875.44)
  532. INSERT INTO Session VALUES ('2012-10-22', '04:38:12', 13, 39, 1672.47)
  533. INSERT INTO Session VALUES ('2014-04-01', '06:46:25', 5, 8, 1901.29)
  534. INSERT INTO Session VALUES ('2015-02-01', '13:25:13', 8, 28, 8921.21)
  535. INSERT INTO Session VALUES ('2013-08-30', '10:52:40', 6, 11, 780.81)
  536. INSERT INTO Session VALUES ('2013-02-09', '17:18:28', 12, 35, 2902.09)
  537. INSERT INTO Session VALUES ('2012-12-07', '22:12:17', 16, 24, 4972.04)
  538. INSERT INTO Session VALUES ('2011-02-26', '11:11:00', 13, 36, 1716.2)
  539. INSERT INTO Session VALUES ('2017-10-10', '16:56:57', 7, 36, 3944.0)
  540. INSERT INTO Session VALUES ('2012-02-25', '21:41:20', 5, 31, 9988.26)
  541. INSERT INTO Session VALUES ('2016-10-10', '16:56:44', 6, 20, 2205.66)
  542. INSERT INTO Session VALUES ('2017-08-21', '06:49:25', 15, 29, 8367.53)
  543. INSERT INTO Session VALUES ('2015-01-13', '00:40:54', 3, 8, 9535.05)
  544. INSERT INTO Session VALUES ('2011-04-27', '22:59:58', 12, 8, 6504.92)
  545. INSERT INTO Session VALUES ('2013-03-17', '11:52:14', 17, 1, 2412.62)
  546. INSERT INTO Session VALUES ('2017-06-16', '18:58:12', 6, 6, 7927.39)
  547. INSERT INTO Session VALUES ('2013-04-13', '17:35:09', 1, 39, 3905.81)
  548. INSERT INTO Session VALUES ('2015-06-19', '20:25:45', 2, 25, 2417.81)
  549. INSERT INTO Session VALUES ('2010-02-27', '14:01:47', 16, 28, 5146.83)
  550. INSERT INTO Session VALUES ('2017-03-30', '08:09:43', 18, 7, 8184.81)
  551. INSERT INTO Session VALUES ('2016-02-25', '08:45:13', 10, 19, 4118.75)
  552. INSERT INTO Session VALUES ('2014-04-15', '17:47:45', 9, 18, 9985.27)
  553. INSERT INTO Session VALUES ('2016-09-23', '20:31:43', 2, 17, 5932.72)
  554. INSERT INTO Session VALUES ('2012-09-05', '03:32:48', 4, 1, 9450.47)
  555. INSERT INTO Session VALUES ('2017-02-04', '22:11:11', 14, 32, 8015.43)
  556. INSERT INTO Session VALUES ('2014-11-12', '07:30:03', 10, 5, 7006.53)
  557. INSERT INTO Session VALUES ('2016-10-16', '21:25:15', 14, 36, 966.05)
  558. INSERT INTO Session VALUES ('2012-08-25', '01:25:10', 2, 37, 7407.21)
  559. INSERT INTO Session VALUES ('2016-11-06', '23:48:29', 8, 8, 6760.93)
  560. INSERT INTO Session VALUES ('2012-12-31', '09:03:39', 17, 19, 8170.73)
  561. INSERT INTO Session VALUES ('2011-01-01', '08:55:47', 5, 9, 800.35)
  562. INSERT INTO Session VALUES ('2010-05-07', '07:29:39', 7, 15, 4334.09)
  563. INSERT INTO Session VALUES ('2012-12-02', '18:56:31', 12, 40, 8898.64)
  564. INSERT INTO Session VALUES ('2011-01-08', '18:10:16', 8, 28, 4968.62)
  565. INSERT INTO Session VALUES ('2012-08-03', '14:03:11', 5, 7, 5548.54)
  566. INSERT INTO Session VALUES ('2011-01-17', '02:28:12', 16, 38, 4198.81)
  567. INSERT INTO Session VALUES ('2014-08-19', '05:19:21', 11, 29, 9992.18)
  568. INSERT INTO Session VALUES ('2014-01-03', '06:38:52', 6, 32, 2826.0)
  569. INSERT INTO Session VALUES ('2015-10-04', '17:32:40', 16, 14, 8214.32)
  570. INSERT INTO Session VALUES ('2015-11-14', '09:14:10', 2, 5, 102.26)
  571. INSERT INTO Session VALUES ('2012-01-11', '21:33:58', 2, 21, 6652.58)
  572. INSERT INTO Session VALUES ('2014-06-13', '04:15:54', 16, 25, 4429.49)
  573. INSERT INTO Session VALUES ('2010-10-15', '18:37:44', 5, 18, 1626.88)
  574. INSERT INTO Session VALUES ('2017-04-03', '20:28:28', 5, 5, 5073.75)
  575. INSERT INTO Session VALUES ('2012-09-08', '02:02:44', 17, 3, 7376.56)
  576. INSERT INTO Session VALUES ('2012-02-18', '10:39:49', 14, 8, 9191.42)
  577. INSERT INTO Session VALUES ('2010-10-27', '17:45:21', 10, 29, 4025.43)
  578. INSERT INTO Session VALUES ('2011-09-18', '12:40:34', 15, 1, 5941.35)
  579. INSERT INTO Session VALUES ('2011-05-18', '15:04:20', 7, 40, 3963.76)
  580. INSERT INTO Session VALUES ('2011-12-31', '21:47:54', 10, 17, 3648.89)
  581. INSERT INTO Session VALUES ('2015-08-19', '05:56:10', 14, 16, 8961.37)
  582. INSERT INTO Session VALUES ('2017-03-15', '14:00:34', 16, 21, 9346.67)
  583. INSERT INTO Session VALUES ('2012-12-01', '16:54:03', 1, 3, 590.05)
  584. INSERT INTO Session VALUES ('2017-06-06', '23:34:18', 1, 21, 5019.22)
  585.  
  586. CREATE TABLE Visit (sessionId INT FOREIGN KEY REFERENCES Session(id) NOT NULL, humanId INT FOREIGN KEY REFERENCES Human(id) NOT NULL, mark TINYINT NOT NULL);
  587. ALTER TABLE dbo.Visit ADD ID INT IDENTITY;
  588. ALTER TABLE dbo.Visit ADD CONSTRAINT PK_Visit PRIMARY KEY(ID);
  589.  
  590. INSERT INTO Visit VALUES (53, 34, 79);
  591. INSERT INTO Visit VALUES (200, 16, 132);
  592. INSERT INTO Visit VALUES (29, 93, 139);
  593. INSERT INTO Visit VALUES (51, 13, 220);
  594. INSERT INTO Visit VALUES (126, 23, 1);
  595. INSERT INTO Visit VALUES (74, 87, 219);
  596. INSERT INTO Visit VALUES (93, 62, 198);
  597. INSERT INTO Visit VALUES (3, 67, 229);
  598. INSERT INTO Visit VALUES (23, 15, 165);
  599. INSERT INTO Visit VALUES (25, 26, 67);
  600. INSERT INTO Visit VALUES (133, 92, 14);
  601. INSERT INTO Visit VALUES (146, 40, 115);
  602. INSERT INTO Visit VALUES (126, 31, 104);
  603. INSERT INTO Visit VALUES (42, 37, 225);
  604. INSERT INTO Visit VALUES (182, 54, 12);
  605. INSERT INTO Visit VALUES (50, 55, 81);
  606. INSERT INTO Visit VALUES (59, 99, 154);
  607. INSERT INTO Visit VALUES (50, 78, 92);
  608. INSERT INTO Visit VALUES (20, 57, 243);
  609. INSERT INTO Visit VALUES (7, 44, 10);
  610. INSERT INTO Visit VALUES (94, 21, 3);
  611. INSERT INTO Visit VALUES (189, 24, 153);
  612. INSERT INTO Visit VALUES (126, 58, 103);
  613. INSERT INTO Visit VALUES (61, 55, 199);
  614. INSERT INTO Visit VALUES (73, 69, 110);
  615. INSERT INTO Visit VALUES (200, 89, 137);
  616. INSERT INTO Visit VALUES (110, 12, 158);
  617. INSERT INTO Visit VALUES (28, 62, 142);
  618. INSERT INTO Visit VALUES (182, 54, 208);
  619. INSERT INTO Visit VALUES (84, 35, 114);
  620. INSERT INTO Visit VALUES (173, 99, 238);
  621. INSERT INTO Visit VALUES (175, 22, 185);
  622. INSERT INTO Visit VALUES (45, 18, 3);
  623. INSERT INTO Visit VALUES (156, 54, 238);
  624. INSERT INTO Visit VALUES (56, 32, 88);
  625. INSERT INTO Visit VALUES (131, 36, 57);
  626. INSERT INTO Visit VALUES (62, 95, 245);
  627. INSERT INTO Visit VALUES (168, 58, 24);
  628. INSERT INTO Visit VALUES (121, 96, 85);
  629. INSERT INTO Visit VALUES (82, 43, 169);
  630. INSERT INTO Visit VALUES (18, 62, 77);
  631. INSERT INTO Visit VALUES (165, 74, 199);
  632. INSERT INTO Visit VALUES (192, 16, 230);
  633. INSERT INTO Visit VALUES (38, 22, 226);
  634. INSERT INTO Visit VALUES (133, 66, 165);
  635. INSERT INTO Visit VALUES (153, 72, 106);
  636. INSERT INTO Visit VALUES (44, 27, 101);
  637. INSERT INTO Visit VALUES (20, 71, 252);
  638. INSERT INTO Visit VALUES (164, 19, 69);
  639. INSERT INTO Visit VALUES (75, 40, 36);
  640. INSERT INTO Visit VALUES (160, 98, 222);
  641. INSERT INTO Visit VALUES (184, 6, 83);
  642. INSERT INTO Visit VALUES (25, 12, 59);
  643. INSERT INTO Visit VALUES (40, 78, 118);
  644. INSERT INTO Visit VALUES (77, 56, 149);
  645. INSERT INTO Visit VALUES (152, 43, 188);
  646. INSERT INTO Visit VALUES (179, 2, 83);
  647. INSERT INTO Visit VALUES (126, 12, 221);
  648. INSERT INTO Visit VALUES (150, 78, 237);
  649. INSERT INTO Visit VALUES (80, 96, 82);
  650. INSERT INTO Visit VALUES (129, 76, 253);
  651. INSERT INTO Visit VALUES (28, 13, 102);
  652. INSERT INTO Visit VALUES (172, 67, 129);
  653. INSERT INTO Visit VALUES (157, 98, 161);
  654. INSERT INTO Visit VALUES (98, 71, 2);
  655. INSERT INTO Visit VALUES (132, 73, 238);
  656. INSERT INTO Visit VALUES (38, 15, 129);
  657. INSERT INTO Visit VALUES (14, 34, 107);
  658. INSERT INTO Visit VALUES (163, 1, 38);
  659. INSERT INTO Visit VALUES (161, 34, 47);
  660. INSERT INTO Visit VALUES (145, 49, 117);
  661. INSERT INTO Visit VALUES (67, 90, 137);
  662. INSERT INTO Visit VALUES (64, 7, 81);
  663. INSERT INTO Visit VALUES (96, 25, 246);
  664. INSERT INTO Visit VALUES (133, 47, 156);
  665. INSERT INTO Visit VALUES (133, 56, 14);
  666. INSERT INTO Visit VALUES (123, 6, 156);
  667. INSERT INTO Visit VALUES (126, 69, 154);
  668. INSERT INTO Visit VALUES (48, 62, 213);
  669. INSERT INTO Visit VALUES (30, 80, 190);
  670. INSERT INTO Visit VALUES (132, 96, 42);
  671. INSERT INTO Visit VALUES (179, 60, 90);
  672. INSERT INTO Visit VALUES (86, 23, 79);
  673. INSERT INTO Visit VALUES (92, 12, 127);
  674. INSERT INTO Visit VALUES (190, 81, 193);
  675. INSERT INTO Visit VALUES (167, 72, 202);
  676. INSERT INTO Visit VALUES (128, 38, 202);
  677. INSERT INTO Visit VALUES (66, 15, 92);
  678. INSERT INTO Visit VALUES (21, 96, 223);
  679. INSERT INTO Visit VALUES (139, 97, 69);
  680. INSERT INTO Visit VALUES (107, 26, 181);
  681. INSERT INTO Visit VALUES (199, 66, 84);
  682. INSERT INTO Visit VALUES (47, 95, 61);
  683. INSERT INTO Visit VALUES (163, 24, 219);
  684. INSERT INTO Visit VALUES (180, 43, 235);
  685. INSERT INTO Visit VALUES (9, 26, 156);
  686. INSERT INTO Visit VALUES (39, 68, 184);
  687. INSERT INTO Visit VALUES (9, 41, 82);
  688. INSERT INTO Visit VALUES (99, 57, 103);
  689. INSERT INTO Visit VALUES (31, 31, 23);
  690. INSERT INTO Visit VALUES (120, 58, 253);
  691. INSERT INTO Visit VALUES (110, 78, 208);
  692. INSERT INTO Visit VALUES (200, 100, 56);
  693. INSERT INTO Visit VALUES (147, 35, 129);
  694. INSERT INTO Visit VALUES (171, 10, 175);
  695. INSERT INTO Visit VALUES (120, 11, 16);
  696. INSERT INTO Visit VALUES (171, 18, 76);
  697. INSERT INTO Visit VALUES (90, 92, 132);
  698. INSERT INTO Visit VALUES (93, 40, 210);
  699. INSERT INTO Visit VALUES (94, 6, 123);
  700. INSERT INTO Visit VALUES (166, 44, 81);
  701. INSERT INTO Visit VALUES (84, 98, 118);
  702. INSERT INTO Visit VALUES (83, 100, 106);
  703. INSERT INTO Visit VALUES (174, 54, 170);
  704. INSERT INTO Visit VALUES (38, 91, 131);
  705. INSERT INTO Visit VALUES (157, 13, 60);
  706. INSERT INTO Visit VALUES (21, 67, 237);
  707. INSERT INTO Visit VALUES (35, 54, 42);
  708. INSERT INTO Visit VALUES (33, 4, 155);
  709. INSERT INTO Visit VALUES (197, 53, 54);
  710. INSERT INTO Visit VALUES (133, 52, 187);
  711. INSERT INTO Visit VALUES (131, 91, 44);
  712. INSERT INTO Visit VALUES (36, 40, 153);
  713. INSERT INTO Visit VALUES (41, 69, 111);
  714. INSERT INTO Visit VALUES (113, 80, 22);
  715. INSERT INTO Visit VALUES (189, 4, 232);
  716. INSERT INTO Visit VALUES (51, 24, 139);
  717. INSERT INTO Visit VALUES (156, 83, 100);
  718. INSERT INTO Visit VALUES (137, 18, 70);
  719. INSERT INTO Visit VALUES (176, 96, 62);
  720. INSERT INTO Visit VALUES (57, 84, 36);
  721. INSERT INTO Visit VALUES (113, 34, 175);
  722. INSERT INTO Visit VALUES (85, 35, 209);
  723. INSERT INTO Visit VALUES (101, 48, 218);
  724. INSERT INTO Visit VALUES (147, 43, 22);
  725. INSERT INTO Visit VALUES (49, 42, 190);
  726. INSERT INTO Visit VALUES (124, 96, 151);
  727. INSERT INTO Visit VALUES (87, 20, 30);
  728. INSERT INTO Visit VALUES (131, 30, 139);
  729. INSERT INTO Visit VALUES (150, 23, 2);
  730. INSERT INTO Visit VALUES (84, 90, 127);
  731. INSERT INTO Visit VALUES (190, 69, 36);
  732. INSERT INTO Visit VALUES (2, 23, 1);
  733. INSERT INTO Visit VALUES (143, 80, 190);
  734. INSERT INTO Visit VALUES (65, 91, 15);
  735. INSERT INTO Visit VALUES (35, 41, 231);
  736. INSERT INTO Visit VALUES (35, 42, 40);
  737. INSERT INTO Visit VALUES (153, 96, 78);
  738. INSERT INTO Visit VALUES (29, 30, 204);
  739. INSERT INTO Visit VALUES (63, 27, 224);
  740. INSERT INTO Visit VALUES (134, 21, 49);
  741. INSERT INTO Visit VALUES (191, 40, 172);
  742. INSERT INTO Visit VALUES (200, 25, 47);
  743. INSERT INTO Visit VALUES (67, 26, 117);
  744. INSERT INTO Visit VALUES (135, 9, 104);
  745. INSERT INTO Visit VALUES (161, 64, 157);
  746. INSERT INTO Visit VALUES (166, 30, 156);
  747. INSERT INTO Visit VALUES (140, 17, 19);
  748. INSERT INTO Visit VALUES (35, 87, 168);
  749. INSERT INTO Visit VALUES (81, 48, 101);
  750. INSERT INTO Visit VALUES (10, 42, 31);
  751. INSERT INTO Visit VALUES (103, 80, 118);
  752. INSERT INTO Visit VALUES (58, 42, 169);
  753. INSERT INTO Visit VALUES (11, 78, 105);
  754. INSERT INTO Visit VALUES (168, 25, 235);
  755. INSERT INTO Visit VALUES (63, 16, 25);
  756. INSERT INTO Visit VALUES (49, 27, 86);
  757. INSERT INTO Visit VALUES (161, 57, 211);
  758. INSERT INTO Visit VALUES (23, 71, 169);
  759. INSERT INTO Visit VALUES (166, 49, 193);
  760. INSERT INTO Visit VALUES (200, 84, 159);
  761. INSERT INTO Visit VALUES (158, 13, 114);
  762. INSERT INTO Visit VALUES (99, 25, 211);
  763. INSERT INTO Visit VALUES (199, 93, 120);
  764. INSERT INTO Visit VALUES (162, 44, 208);
  765. INSERT INTO Visit VALUES (89, 55, 77);
  766. INSERT INTO Visit VALUES (124, 15, 203);
  767. INSERT INTO Visit VALUES (23, 74, 27);
  768. INSERT INTO Visit VALUES (93, 63, 117);
  769. INSERT INTO Visit VALUES (87, 41, 49);
  770. INSERT INTO Visit VALUES (97, 82, 34);
  771. INSERT INTO Visit VALUES (158, 88, 161);
  772. INSERT INTO Visit VALUES (4, 52, 47);
  773. INSERT INTO Visit VALUES (172, 87, 97);
  774. INSERT INTO Visit VALUES (30, 9, 199);
  775. INSERT INTO Visit VALUES (87, 66, 174);
  776. INSERT INTO Visit VALUES (61, 80, 121);
  777. INSERT INTO Visit VALUES (175, 99, 161);
  778. INSERT INTO Visit VALUES (123, 66, 1);
  779. INSERT INTO Visit VALUES (56, 55, 208);
  780. INSERT INTO Visit VALUES (134, 52, 33);
  781. INSERT INTO Visit VALUES (154, 53, 32);
  782. INSERT INTO Visit VALUES (30, 88, 105);
  783. INSERT INTO Visit VALUES (183, 24, 211);
  784. INSERT INTO Visit VALUES (70, 58, 106);
  785. INSERT INTO Visit VALUES (163, 54, 178);
  786. INSERT INTO Visit VALUES (22, 94, 238);
  787. INSERT INTO Visit VALUES (82, 45, 155);
  788. INSERT INTO Visit VALUES (38, 54, 111);
  789. INSERT INTO Visit VALUES (189, 91, 241);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!