Advertisement
MirandaWopps

Insertions to Schema Filmes

May 11th, 2024 (edited)
821
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. INSERT INTO Filme (idFilme, filmeNome, ano, genero)
  2. VALUES
  3.     (1, 'Jarhead', 2005, 'Guerra'),
  4.     (2, 'Hacksaw Ridge', 2016, 'Guerra'),
  5.     (3, 'Letters from Iwo Jima', 2006 , 'Guerra'),
  6.     (4, 'Saving Private Ryan', 1998, 'Guerra'),
  7.     (5, 'Apocalypse Now', 1979, 'Guerra'),
  8.     (6, 'Full Metal Jacket', 1987, 'Guerra'),
  9.     (7, 'Platoon', 1986, 'Guerra'),
  10.     (8, 'Das Boot', 1981, 'Guerra'),
  11.     (9, 'Black Hawk Down', 2001, 'Guerra'),
  12.     (10, 'Fury', 2014, 'Guerra'),
  13.     (11, 'Enemy at the Gates', 2001, 'Guerra'),
  14.     (12, 'The Thin Red Line', 1998, 'Guerra'),
  15.     (13, '1917', 2019, 'Guerra'),
  16.     (14, 'The Hurt Locker', 2008, 'Guerra'),
  17.     (15, 'We Were Soldiers', 2002, 'Guerra'),
  18.     (16, 'Dunkirk', 2017, 'Guerra'),
  19.     (17, 'Tears of the Sun', 2003, 'Guerra'),
  20.     (18, 'Windtalkers', 2002, 'Guerra'),
  21.     (19, 'Jarhead 2: Field of Fire', 2014, 'Guerra'),
  22.     (20, 'Hamburger Hill', 1987, 'Guerra'),
  23.     (21, 'Casualties of War', 1989, 'Guerra'),
  24.     (22, 'The Deer Hunter', 1978, 'Guerra'),
  25.     (23, 'Tora! Tora! Tora!', 1970, 'Guerra'),
  26.     (24, 'The Bridge on the River Kwai', 1957, 'Guerra'),
  27.     (25, 'Flags of Our Fathers', 2006, 'Guerra');
  28. ;
  29.  
  30.  
  31. -- Inserindo atores associados aos filmes na tabela Ator
  32. INSERT INTO filmes.Ator (idAtor, idFilmeA, atorNome)
  33. VALUES
  34.     -- Atores de "Jarhead" (idFilme = 1)
  35.     (1, 1, 'Jake Gyllenhaal'),
  36.     (2, 1, 'Jamie Foxx'),
  37.     (3, 1, 'Peter Sarsgaard'),
  38.  
  39.     -- Atores de "Hacksaw Ridge" (idFilme = 2)
  40.     (4, 2, 'Andrew Garfield'),
  41.     (5, 2, 'Sam Worthington'),
  42.     (6, 2, 'Luke Bracey'),
  43.  
  44.     -- Atores de "Letters from Iwo Jima" (idFilme = 3)
  45.     (7, 3, 'Ken Watanabe'),
  46.     (8, 3, 'Kazunari Ninomiya'),
  47.     (9, 3, 'Tsuyoshi Ihara'),
  48.  
  49.     -- Atores de "Saving Private Ryan" (idFilme = 4)
  50.     (10, 4, 'Tom Hanks'),
  51.     (11, 4, 'Matt Damon'),
  52.     (12, 4, 'Tom Sizemore'),
  53.  
  54.     -- Atores de "Apocalypse Now" (idFilme = 5)
  55.     (13, 5, 'Martin Sheen'),
  56.     (14, 5, 'Marlon Brando'),
  57.     (15, 5, 'Robert Duvall'),
  58.  
  59.     -- Atores de "Full Metal Jacket" (idFilme = 6)
  60.     (16, 6, 'Matthew Modine'),
  61.     (17, 6, 'Adam Baldwin'),
  62.     (18, 6, 'Vincent D''Onofrio'),
  63.  
  64.     -- Atores de "Platoon" (idFilme = 7)
  65.     (19, 7, 'Charlie Sheen'),
  66.     (20, 7, 'Willem Dafoe'),
  67.     (21, 7, 'Tom Berenger'),
  68.  
  69.     -- Atores de "Das Boot" (idFilme = 8)
  70.     (22, 8, 'Jürgen Prochnow'),
  71.     (23, 8, 'Herbert Grönemeyer'),
  72.     (24, 8, 'Klaus Wennemann'),
  73.  
  74.     -- Atores de "Black Hawk Down" (idFilme = 9)
  75.     (25, 9, 'Josh Hartnett'),
  76.     (26, 9, 'Ewan McGregor'),
  77.     (27, 9, 'Tom Sizemore'),
  78.  
  79.     -- Atores de "Fury" (idFilme = 10)
  80.     (28, 10, 'Brad Pitt'),
  81.     (29, 10, 'Shia LaBeouf'),
  82.     (30, 10, 'Logan Lerman'),
  83.  
  84.     -- Atores de "Enemy at the Gates" (idFilme = 11)
  85.     (31, 11, 'Jude Law'),
  86.     (32, 11, 'Ed Harris'),
  87.     (33, 11, 'Rachel Weisz'),
  88.  
  89.     -- Atores de "The Thin Red Line" (idFilme = 12)
  90.     (34, 12, 'Sean Penn'),
  91.     (35, 12, 'Jim Caviezel'),
  92.     (36, 12, 'Nick Nolte'),
  93.  
  94.     -- Atores de "1917" (idFilme = 13)
  95.     (37, 13, 'George MacKay'),
  96.     (38, 13, 'Dean-Charles Chapman'),
  97.     (39, 13, 'Mark Strong'),
  98.  
  99.     -- Atores de "The Hurt Locker" (idFilme = 14)
  100.     (40, 14, 'Jeremy Renner'),
  101.     (41, 14, 'Anthony Mackie'),
  102.     (42, 14, 'Brian Geraghty'),
  103.  
  104.     -- Atores de "We Were Soldiers" (idFilme = 15)
  105.     (43, 15, 'Mel Gibson'),
  106.     (44, 15, 'Madeleine Stowe'),
  107.     (45, 15, 'Greg Kinnear'),
  108.  
  109.     -- Atores de "Dunkirk" (idFilme = 16)
  110.     (46, 16, 'Fionn Whitehead'),
  111.     (47, 16, 'Tom Glynn-Carney'),
  112.     (48, 16, 'Jack Lowden'),
  113.  
  114.     -- Atores de "Tears of the Sun" (idFilme = 17)
  115.     (49, 17, 'Bruce Willis'),
  116.     (50, 17, 'Monica Bellucci'),
  117.     (51, 17, 'Cole Hauser'),
  118.  
  119.     -- Atores de "Windtalkers" (idFilme = 18)
  120.     (52, 18, 'Nicolas Cage'),
  121.     (53, 18, 'Adam Beach'),
  122.     (54, 18, 'Peter Stormare'),
  123.  
  124.     -- Atores de "Jarhead 2: Field of Fire" (idFilme = 19)
  125.     (55, 19, 'Josh Kelly'),
  126.     (56, 19, 'Cole Hauser'),
  127.     (57, 19, 'Danielle Savre'),
  128.  
  129.     -- Atores de "Hamburger Hill" (idFilme = 20)
  130.     (58, 20, 'Dylan McDermott'),
  131.     (59, 20, 'Steven Weber'),
  132.     (60, 20, 'Courtney B. Vance'),
  133.  
  134.     -- Atores de "Casualties of War" (idFilme = 21)
  135.     (61, 21, 'Michael J. Fox'),
  136.     (62, 21, 'Sean Penn'),
  137.     (63, 21, 'Don Harvey'),
  138.  
  139.     -- Atores de "The Deer Hunter" (idFilme = 22)
  140.     (64, 22, 'Robert De Niro'),
  141.     (65, 22, 'Christopher Walken'),
  142.     (66, 22, 'John Cazale'),
  143.  
  144.     -- Atores de "Tora! Tora! Tora!" (idFilme = 23)
  145.     (67, 23, 'Martin Balsam'),
  146.     (68, 23, 'Sô Yamamura'),
  147.     (69, 23, 'Joseph Cotten'),
  148.  
  149.     -- Atores de "The Bridge on the River Kwai" (idFilme = 24)
  150.     (70, 24, 'William Holden'),
  151.     (71, 24, 'Alec Guinness'),
  152.     (72, 24, 'Jack Hawkins'),
  153.  
  154.     -- Atores de "Flags of Our Fathers" (idFilme = 25)
  155.     (73, 25, 'Ryan Phillippe'),
  156.     (74, 25, 'Jesse Bradford'),
  157.     (75, 25, 'Adam Beach');
  158.  
  159.  
  160. INSERT INTO filmes.cliente VALUES (12345678901 , 'John');
  161.  
  162. INSERT INTO filmes.critica VALUES (1, 12345678901 , 10, 'Waw, nao e minha conta principal nem meu cpf real, mas esse filme teve grande impacto na formação do meu carater. Q filme legal !', CURRENT_DATE);
  163.  
  164. INSERT INTO filmes.venda VALUES (1, 12345678901 , 60.00 ,  '2016-05-11');
  165.  
  166.  
  167.  
  168.  
  169.  
  170.  
  171.  
  172.  
  173. INSERT INTO filmes.cliente (cpf, nome) VALUES
  174. ('12345678900', 'Alice Silva'),
  175. ('23456789012', 'Bob Santos'),
  176. ('34567890123', 'Carol Oliveira'),
  177. ('45678901234', 'David Souza'),
  178. ('56789012345', 'Eve Lima'),
  179. ('67890123456', 'Frank Costa'),
  180. ('78901234567', 'Grace Ferreira'),
  181. ('89012345678', 'Hank Rocha'),
  182. ('90123456789', 'Ivy Gomes'),
  183. ('01234567890', 'Jack Ribeiro'),
  184. ('11234567890', 'Karen Martins'),
  185. ('12234567890', 'Leo Alves'),
  186. ('13234567890', 'Mia Castro'),
  187. ('14234567890', 'Nina Mendes'),
  188. ('15234567890', 'Oscar Barreto'),
  189. ('16234567890', 'Paul Teixeira'),
  190. ('17234567890', 'Quinn Correia'),
  191. ('18234567890', 'Rita Pinto'),
  192. ('19234567890', 'Sam Duarte'),
  193. ('20234567890', 'Tina Melo'),
  194. ('21234567890', 'Uma Vieira'),
  195. ('22234567890', 'Victor Xavier'),
  196. ('23234567890', 'Wendy Almeida'),
  197. ('24234567890', 'Xander Moreira'),
  198. ('25234567890', 'Yara Barros'),
  199. ('26234567890', 'Zane Brito'),
  200. ('27234567890', 'Anna Cardoso'),
  201. ('28234567890', 'Bruno Carvalho'),
  202. ('29234567890', 'Clara Farias'),
  203. ('30234567890', 'Danilo Souza'),
  204. ('31234567890', 'Elisa Goncalves'),
  205. ('32234567890', 'Felipe Reis'),
  206. ('33234567890', 'Gabriela Rocha'),
  207. ('34234567890', 'Heitor Lima'),
  208. ('35234567890', 'Isabela Alves'),
  209. ('36234567890', 'Jorge Martins'),
  210. ('37234567890', 'Lara Duarte'),
  211. ('38234567890', 'Marcos Castro'),
  212. ('39234567890', 'Natalia Ferreira'),
  213. ('40234567890', 'Otavio Mendes'),
  214. ('41234567890', 'Patricia Correia'),
  215. ('42234567890', 'Renato Costa'),
  216. ('43234567890', 'Sofia Gomes'),
  217. ('44234567890', 'Thiago Ribeiro'),
  218. ('45234567890', 'Vanessa Pinto'),
  219. ('46234567890', 'Willian Rocha'),
  220. ('47234567890', 'Ximena Teixeira'),
  221. ('48234567890', 'Yuri Vieira'),
  222. ('49234567890', 'Zoe Almeida'),
  223. ('50234567890', 'Aline Moreira'),
  224. ('51234567890', 'Carlos Barros'),
  225. ('52234567890', 'Diana Brito'),
  226. ('53234567890', 'Eduardo Cardoso'),
  227. ('54234567890', 'Fernanda Carvalho'),
  228. ('55234567890', 'Gustavo Farias'),
  229. ('56234567890', 'Helena Souza'),
  230. ('57234567890', 'Igor Goncalves'),
  231. ('58234567890', 'Juliana Reis'),
  232. ('59234567890', 'Kaique Rocha'),
  233. ('60234567890', 'Luana Lima'),
  234. ('61234567890', 'Matheus Alves'),
  235. ('62234567890', 'Nicole Martins'),
  236. ('63234567890', 'Paulo Duarte'),
  237. ('64234567890', 'Raquel Castro'),
  238. ('65234567890', 'Sergio Ferreira'),
  239. ('66234567890', 'Tatiana Mendes'),
  240. ('67234567890', 'Vinicius Correia'),
  241. ('68234567890', 'Wesley Costa'),
  242. ('69234567890', 'Yasmin Gomes'),
  243. ('70234567890', 'Zeca Ribeiro'),
  244. ('71234567890', 'Amanda Pinto'),
  245. ('72234567890', 'Bernardo Rocha'),
  246. ('73234567890', 'Camila Teixeira'),
  247. ('74234567890', 'Diego Vieira'),
  248. ('75234567890', 'Emilia Almeida'),
  249. ('76234567890', 'Fabio Moreira'),
  250. ('77234567890', 'Giulia Barros'),
  251. ('78234567890', 'Henrique Brito'),
  252. ('79234567890', 'Isis Cardoso'),
  253. ('80234567890', 'Jose Carvalho'),
  254. ('81234567890', 'Leticia Farias'),
  255. ('82234567890', 'Marcelo Souza'),
  256. ('83234567890', 'Nathalia Goncalves'),
  257. ('84234567890', 'Pedro Reis'),
  258. ('85234567890', 'Rafaela Rocha'),
  259. ('86234567890', 'Samuel Lima'),
  260. ('87234567890', 'Tamires Alves'),
  261. ('88234567890', 'Ursula Martins'),
  262. ('89234567890', 'Vicente Duarte'),
  263. ('90234567890', 'William Castro'),
  264. ('91234567890', 'Xenia Ferreira'),
  265. ('92234567890', 'Yago Mendes'),
  266. ('93234567890', 'Zara Correia'),
  267. ('94234567890', 'Alice Costa'),
  268. ('95234567890', 'Bruna Gomes'),
  269. ('96234567890', 'Caio Ribeiro'),
  270. ('97234567890', 'Daniel Pinto'),
  271. ('98234567890', 'Eloisa Rocha'),
  272. ('99234567890', 'Felipe Teixeira'),
  273. ('10023456789', 'Gustavo Vieira'),
  274. ('10123456789', 'Helena Almeida'),
  275. ('10223456789', 'Ivo Moreira'),
  276. ('10323456789', 'Julia Barros'),
  277. ('10423456789', 'Kauã Brito'),
  278. ('10523456789', 'Laura Cardoso'),
  279. ('10623456789', 'Mário Carvalho'),
  280. ('10723456789', 'Natália Farias'),
  281. ('10823456789', 'Otávio Souza'),
  282. ('10923456789', 'Paula Gonçalves'),
  283. ('11023456789', 'Roberto Reis'),
  284. ('11123456789', 'Simone Rocha'),
  285. ('11223456789', 'Tiago Lima'),
  286. ('11323456789', 'Vanessa Alves'),
  287. ('11423456789', 'Wellington Martins'),
  288. ('11523456789', 'Ximena Duarte'),
  289. ('11623456789', 'Yasmin Castro'),
  290. ('11723456789', 'Zeca Ferreira'),
  291. ('11823456789', 'Amanda Mendes'),
  292. ('11923456789', 'Bruno Correia'),
  293. ('12023456789', 'Carlos Costa'),
  294. ('12123456789', 'Diana Gomes'),
  295. ('12223456789', 'Eduardo Ribeiro'),
  296. ('12323456789', 'Fernanda Pinto'),
  297. ('12423456789', 'Gabriel Rocha'),
  298. ('12523456789', 'Helena Teixeira'),
  299. ('12623456789', 'Igor Vieira'),
  300. ('12723456789', 'Juliana Almeida'),
  301. ('12823456789', 'Kaio Moreira'),
  302. ('12923456789', 'Larissa Barros'),
  303. ('13023456789', 'Marcos Brito'),
  304. ('13123456789', 'Natália Cardoso'),
  305. ('13223456789', 'Otávio Carvalho'),
  306. ('13323456789', 'Patrícia Farias'),
  307. ('13423456789', 'Ricardo Souza'),
  308. ('13523456789', 'Simone Gonçalves'),
  309. ('13623456789', 'Tadeu Reis'),
  310. ('13723456789', 'Viviane Rocha'),
  311. ('13823456789', 'William Lima'),
  312. ('13923456789', 'Xavier Alves'),
  313. ('14023456789', 'Yuri Martins'),
  314. ('14123456789', 'Zoe Duarte'),
  315. ('14223456789', 'Alice Castro'),
  316. ('14323456789', 'Bruno Ferreira'),
  317. ('14423456789', 'Camila Mendes'),
  318. ('14523456789', 'Daniel Correia'),
  319. ('14623456789', 'Emília Costa'),
  320. ('14723456789', 'Fábio Gomes'),
  321. ('14823456789', 'Giulia Ribeiro'),
  322. ('14923456789', 'Henrique Pinto'),
  323. ('15023456789', 'Isabela Rocha'),
  324. ('15123456789', 'João Teixeira'),
  325. ('15223456789', 'Karla Vieira'),
  326. ('15323456789', 'Luís Almeida'),
  327. ('15423456789', 'Marina Moreira'),
  328. ('15523456789', 'Nicole Barros'),
  329. ('15623456789', 'Otávio Brito'),
  330. ('15723456789', 'Paula Cardoso'),
  331. ('15823456789', 'Renato Carvalho'),
  332. ('15923456789', 'Sônia Farias'),
  333. ('16023456789', 'Tadeu Souza'),
  334. ('16123456789', 'Viviane Gonçalves'),
  335. ('16223456789', 'Wagner Reis'),
  336. ('16323456789', 'Ximena Rocha'),
  337. ('16423456789', 'Yasmin Lima'),
  338. ('16523456789', 'Zeca Alves'),
  339. ('16623456789', 'Amanda Martins'),
  340. ('16723456789', 'Bruno Duarte'),
  341. ('16823456789', 'Carlos Castro'),
  342. ('16923456789', 'Diana Ferreira'),
  343. ('17023456789', 'Eduardo Mendes'),
  344. ('17123456789', 'Fernanda Correia'),
  345. ('17223456789', 'Gabriel Costa'),
  346. ('17323456789', 'Helena Gomes'),
  347. ('17423456789', 'Igor Ribeiro'),
  348. ('17523456789', 'Juliana Pinto'),
  349. ('17623456789', 'Kaio Rocha'),
  350. ('17723456789', 'Larissa Teixeira'),
  351. ('17823456789', 'Marcos Vieira'),
  352. ('17923456789', 'Natália Almeida'),
  353. ('18023456789', 'Otávio Moreira'),
  354. ('18123456789', 'Patrícia Barros'),
  355. ('18223456789', 'Ricardo Brito'),
  356. ('18323456789', 'Simone Cardoso'),
  357. ('18423456789', 'Tadeu Carvalho'),
  358. ('18523456789', 'Viviane Farias'),
  359. ('18623456789', 'William Souza'),
  360. ('18723456789', 'Xavier Gonçalves'),
  361. ('18823456789', 'Yuri Reis'),
  362. ('18923456789', 'Zoe Rocha'),
  363. ('19023456789', 'Alice Lima'),
  364. ('19123456789', 'Bruno Alves'),
  365. ('19223456789', 'Camila Martins'),
  366. ('19323456789', 'Daniel Duarte'),
  367. ('19423456789', 'Emília Castro'),
  368. ('19523456789', 'Fábio Ferreira'),
  369. ('19623456789', 'Giulia Mendes'),
  370. ('19723456789', 'Henrique Correia'),
  371. ('19823456789', 'Isabela Costa'),
  372. ('19923456789', 'João Gomes'),
  373. ('20023456789', 'Karla Ribeiro'),
  374. ('20123456789', 'Luís Pinto'),
  375. ('20223456789', 'Marina Rocha'),
  376. ('20323456789', 'Nicole Teixeira'),
  377. ('20423456789', 'Otávio Vieira'),
  378. ('20523456789', 'Paula Almeida'),
  379. ('20623456789', 'Renato Moreira'),
  380. ('20723456789', 'Sônia Barros'),
  381. ('20823456789', 'Tadeu Brito'),
  382. ('20923456789', 'Viviane Cardoso'),
  383. ('21023456789', 'Wagner Carvalho'),
  384. ('21123456789', 'Ximena Farias'),
  385. ('21223456789', 'Yasmin Souza'),
  386. ('21323456789', 'Zeca Gonçalves'),
  387. ('21423456789', 'Amanda Reis'),
  388. ('21523456789', 'Bruno Rocha'),
  389. ('21623456789', 'Carlos Lima'),
  390. ('21723456789', 'Diana Alves'),
  391. ('21823456789', 'Eduardo Martins'),
  392. ('21923456789', 'Fernanda Duarte'),
  393. ('22023456789', 'Gabriel Castro'),
  394. ('22123456789', 'Helena Ferreira'),
  395. ('22223456789', 'Igor Mendes'),
  396. ('22323456789', 'Juliana Correia'),
  397. ('22423456789', 'Kaio Costa'),
  398. ('22523456789', 'Larissa Gomes'),
  399. ('22623456789', 'Marcos Ribeiro'),
  400. ('22723456789', 'Natália Pinto'),
  401. ('22823456789', 'Otávio Rocha'),
  402. ('22923456789', 'Patrícia Teixeira'),
  403. ('23023456789', 'Ricardo Vieira'),
  404. ('23123456789', 'Simone Almeida'),
  405. ('23223456789', 'Tadeu Moreira'),
  406. ('23323456789', 'Viviane Barros'),
  407. ('23423456789', 'William Brito'),
  408. ('23523456789', 'Xavier Cardoso'),
  409. ('23623456789', 'Yuri Carvalho'),
  410. ('23723456789', 'Zoe Farias'),
  411. ('23823456789', 'Alice Souza'),
  412. ('23923456789', 'Bruno Gonçalves'),
  413. ('24023456789', 'Camila Reis'),
  414. ('24123456789', 'Daniel Rocha'),
  415. ('24223456789', 'Emília Lima'),
  416. ('24323456789', 'Fábio Alves'),
  417. ('24423456789', 'Giulia Martins'),
  418. ('24523456789', 'Henrique Duarte'),
  419. ('24623456789', 'Isabela Castro'),
  420. ('24723456789', 'João Ferreira'),
  421. ('24823456789', 'Karla Mendes'),
  422. ('24923456789', 'Luís Correia'),
  423. ('25023456789', 'Marina Costa'),
  424. ('25123456789', 'Nicole Gomes'),
  425. ('25223456789', 'Otávio Ribeiro'),
  426. ('25323456789', 'Paula Pinto'),
  427. ('25423456789', 'Renato Rocha'),
  428. ('25523456789', 'Sônia Teixeira'),
  429. ('25623456789', 'Tadeu Vieira'),
  430. ('25723456789', 'Viviane Almeida'),
  431. ('25823456789', 'Wagner Moreira'),
  432. ('25923456789', 'Ximena Barros'),
  433. ('26023456789', 'Yasmin Brito'),
  434. ('26123456789', 'Zeca Cardoso'),
  435. ('26223456789', 'Amanda Carvalho'),
  436. ('26323456789', 'Bruno Farias'),
  437. ('26423456789', 'Carlos Souza'),
  438. ('26523456789', 'Diana Gonçalves'),
  439. ('26623456789', 'Eduardo Reis'),
  440. ('26723456789', 'Fernanda Rocha'),
  441. ('26823456789', 'Gabriel Lima'),
  442. ('26923456789', 'Helena Alves'),
  443. ('27023456789', 'Igor Martins'),
  444. ('27123456789', 'Juliana Duarte'),
  445. ('27223456789', 'Kaio Castro'),
  446. ('27323456789', 'Larissa Ferreira'),
  447. ('27423456789', 'Marcos Mendes'),
  448. ('27523456789', 'Natália Correia'),
  449. ('27623456789', 'Otávio Costa'),
  450. ('27723456789', 'Patrícia Gomes'),
  451. ('27823456789', 'Ricardo Ribeiro'),
  452. ('27923456789', 'Simone Pinto'),
  453. ('28023456789', 'Tadeu Rocha'),
  454. ('28123456789', 'Viviane Teixeira'),
  455. ('28223456789', 'William Vieira'),
  456. ('28323456789', 'Xavier Almeida'),
  457. ('28423456789', 'Yuri Moreira'),
  458. ('28523456789', 'Zoe Barros'),
  459. ('28623456789', 'Alice Brito'),
  460. ('28723456789', 'Bruno Cardoso'),
  461. ('28823456789', 'Camila Carvalho'),
  462. ('28923456789', 'Daniel Farias'),
  463. ('29023456789', 'Emília Souza'),
  464. ('29123456789', 'Fábio Gonçalves'),
  465. ('29223456789', 'Giulia Reis'),
  466. ('29323456789', 'Henrique Rocha'),
  467. ('29423456789', 'Isabela Lima'),
  468. ('29523456789', 'João Alves'),
  469. ('29623456789', 'Karla Martins'),
  470. ('29723456789', 'Luís Duarte'),
  471. ('29823456789', 'Marina Castro'),
  472. ('29923456789', 'Nicole Ferreira'),
  473. ('30023456789', 'Otávio Mendes'),
  474. ('30123456789', 'Paula Correia'),
  475. ('30223456789', 'Renato Costa'),
  476. ('30323456789', 'Sônia Gomes'),
  477. ('30423456789', 'Tadeu Ribeiro'),
  478. ('30523456789', 'Viviane Pinto'),
  479. ('30623456789', 'Wagner Rocha'),
  480. ('30723456789', 'Ximena Teixeira'),
  481. ('30823456789', 'Yasmin Vieira'),
  482. ('30923456789', 'Zeca Almeida'),
  483. ('31023456789', 'Amanda Moreira'),
  484. ('31123456789', 'Bruno Barros'),
  485. ('31223456789', 'Carlos Brito'),
  486. ('31323456789', 'Diana Cardoso'),
  487. ('31423456789', 'Eduardo Carvalho'),
  488. ('31523456789', 'Fernanda Farias'),
  489. ('31623456789', 'Gabriel Souza'),
  490. ('31723456789', 'Helena Gonçalves'),
  491. ('31823456789', 'Igor Reis'),
  492. ('31923456789', 'Juliana Rocha'),
  493. ('32023456789', 'Kaio Lima'),
  494. ('32123456789', 'Larissa Alves'),
  495. ('32223456789', 'Marcos Martins'),
  496. ('32323456789', 'Natália Duarte'),
  497. ('32423456789', 'Otávio Castro'),
  498. ('32523456789', 'Patrícia Ferreira'),
  499. ('32623456789', 'Ricardo Mendes'),
  500. ('32723456789', 'Simone Correia'),
  501. ('32823456789', 'Tadeu Costa'),
  502. ('32923456789', 'Viviane Gomes'),
  503. ('33023456789', 'William Ribeiro'),
  504. ('33123456789', 'Xavier Pinto'),
  505. ('33223456789', 'Yuri Rocha'),
  506. ('33323456789', 'Zoe Teixeira'),
  507. ('33423456789', 'Alice Vieira'),
  508. ('33523456789', 'Bruno Almeida'),
  509. ('33623456789', 'Camila Moreira'),
  510. ('33723456789', 'Daniel Barros'),
  511. ('33823456789', 'Emília Brito'),
  512. ('33923456789', 'Fábio Cardoso'),
  513. ('34023456789', 'Giulia Carvalho'),
  514. ('34123456789', 'Henrique Farias'),
  515. ('34223456789', 'Isabela Souza'),
  516. ('34323456789', 'João Gonçalves'),
  517. ('34423456789', 'Karla Reis'),
  518. ('34523456789', 'Luís Rocha'),
  519. ('34623456789', 'Marina Lima'),
  520. ('34723456789', 'Nicole Alves'),
  521. ('34823456789', 'Otávio Martins'),
  522. ('34923456789', 'Paula Duarte'),
  523. ('35023456789', 'Renato Castro'),
  524. ('35123456789', 'Sônia Ferreira'),
  525. ('35223456789', 'Tadeu Mendes'),
  526. ('35323456789', 'Viviane Correia'),
  527. ('35423456789', 'Wagner Costa'),
  528. ('35523456789', 'Ximena Gomes'),
  529. ('35623456789', 'Yasmin Ribeiro'),
  530. ('35723456789', 'Zeca Pinto'),
  531. ('35823456789', 'Amanda Rocha'),
  532. ('35923456789', 'Bruno Teixeira'),
  533. ('36023456789', 'Carlos Vieira'),
  534. ('36123456789', 'Diana Almeida'),
  535. ('36223456789', 'Eduardo Moreira'),
  536. ('36323456789', 'Fernanda Barros'),
  537. ('36423456789', 'Gabriel Brito'),
  538. ('36523456789', 'Helena Cardoso'),
  539. ('36623456789', 'Igor Carvalho'),
  540. ('36723456789', 'Juliana Farias'),
  541. ('36823456789', 'Kaio Souza'),
  542. ('36923456789', 'Larissa Gonçalves'),
  543. ('37023456789', 'Marcos Reis'),
  544. ('37123456789', 'Natália Rocha'),
  545. ('37223456789', 'Otávio Lima'),
  546. ('37323456789', 'Patrícia Alves'),
  547. ('37423456789', 'Ricardo Martins'),
  548. ('37523456789', 'Simone Duarte'),
  549. ('37623456789', 'Tadeu Castro'),
  550. ('37723456789', 'Viviane Ferreira'),
  551. ('37823456789', 'William Mendes'),
  552. ('37923456789', 'Xavier Correia'),
  553. ('38023456789', 'Yuri Costa'),
  554. ('38123456789', 'Zoe Gomes'),
  555. ('38223456789', 'Alice Ribeiro'),
  556. ('38323456789', 'Bruno Pinto'),
  557. ('38423456789', 'Camila Rocha'),
  558. ('38523456789', 'Daniel Teixeira'),
  559. ('38623456789', 'Emília Vieira'),
  560. ('38723456789', 'Fábio Almeida'),
  561. ('38823456789', 'Giulia Moreira'),
  562. ('38923456789', 'Henrique Barros'),
  563. ('39023456789', 'Isabela Brito'),
  564. ('39123456789', 'João Cardoso'),
  565. ('39223456789', 'Karla Carvalho'),
  566. ('39323456789', 'Luís Farias'),
  567. ('39423456789', 'Marina Souza'),
  568. ('39523456789', 'Nicole Gonçalves'),
  569. ('39623456789', 'Otávio Reis'),
  570. ('39723456789', 'Paula Rocha'),
  571. ('39823456789', 'Renato Lima'),
  572. ('39923456789', 'Sônia Alves'),
  573. ('40023456789', 'Tadeu Martins'),
  574. ('40123456789', 'Viviane Duarte'),
  575. ('40223456789', 'Wagner Castro'),
  576. ('40323456789', 'Ximena Ferreira'),
  577. ('40423456789', 'Yasmin Mendes'),
  578. ('40523456789', 'Zeca Correia'),
  579. ('40623456789', 'Amanda Costa'),
  580. ('40723456789', 'Bruno Gomes'),
  581. ('40823456789', 'Carlos Ribeiro'),
  582. ('40923456789', 'Diana Pinto'),
  583. ('41023456789', 'Eduardo Rocha'),
  584. ('41123456789', 'Fernanda Teixeira'),
  585. ('41223456789', 'Gabriel Vieira'),
  586. ('41323456789', 'Helena Almeida'),
  587. ('41423456789', 'Igor Moreira'),
  588. ('41523456789', 'Juliana Barros'),
  589. ('41623456789', 'Kaio Brito'),
  590. ('41723456789', 'Larissa Cardoso'),
  591. ('41823456789', 'Marcos Carvalho'),
  592. ('41923456789', 'Natália Farias'),
  593. ('42023456789', 'Otávio Souza'),
  594. ('42123456789', 'Patrícia Gonçalves'),
  595. ('42223456789', 'Ricardo Reis'),
  596. ('42323456789', 'Simone Rocha'),
  597. ('42423456789', 'Tadeu Lima'),
  598. ('42523456789', 'Viviane Alves'),
  599. ('42623456789', 'William Martins'),
  600. ('42723456789', 'Xavier Duarte'),
  601. ('42823456789', 'Yuri Castro'),
  602. ('42923456789', 'Zoe Ferreira'),
  603. ('43023456789', 'Alice Mendes'),
  604. ('43123456789', 'Bruno Correia'),
  605. ('43223456789', 'Camila Costa'),
  606. ('43323456789', 'Daniel Gomes'),
  607. ('43423456789', 'Emília Ribeiro'),
  608. ('43523456789', 'Fábio Pinto'),
  609. ('43623456789', 'Giulia Rocha'),
  610. ('43723456789', 'Henrique Teixeira'),
  611. ('43823456789', 'Isabela Vieira'),
  612. ('43923456789', 'João Almeida'),
  613. ('44023456789', 'Karla Moreira'),
  614. ('44123456789', 'Luís Barros'),
  615. ('44223456789', 'Marina Brito'),
  616. ('44323456789', 'Nicole Cardoso'),
  617. ('44423456789', 'Otávio Carvalho'),
  618. ('44523456789', 'Paula Farias'),
  619. ('44623456789', 'Renato Souza'),
  620. ('44723456789', 'Sônia Gonçalves'),
  621. ('44823456789', 'Tadeu Reis'),
  622. ('44923456789', 'Viviane Rocha'),
  623. ('45023456789', 'Wagner Lima'),
  624. ('45123456789', 'Ximena Alves'),
  625. ('45223456789', 'Yasmin Martins'),
  626. ('45323456789', 'Zeca Duarte'),
  627. ('45423456789', 'Amanda Castro'),
  628. ('45523456789', 'Bruno Ferreira'),
  629. ('45623456789', 'Carlos Mendes'),
  630. ('45723456789', 'Diana Correia'),
  631. ('45823456789', 'Eduardo Costa'),
  632. ('45923456789', 'Fernanda Gomes'),
  633. ('46023456789', 'Gabriel Ribeiro'),
  634. ('46123456789', 'Helena Pinto'),
  635. ('46223456789', 'Igor Rocha'),
  636. ('46323456789', 'Juliana Teixeira'),
  637. ('46423456789', 'Kaio Vieira'),
  638. ('46523456789', 'Larissa Almeida'),
  639. ('46623456789', 'Marcos Moreira'),
  640. ('46723456789', 'Natália Barros'),
  641. ('46823456789', 'Otávio Brito'),
  642. ('46923456789', 'Patrícia Cardoso'),
  643. ('47023456789', 'Ricardo Carvalho'),
  644. ('47123456789', 'Simone Farias'),
  645. ('47223456789', 'Tadeu Souza'),
  646. ('47323456789', 'Viviane Gonçalves'),
  647. ('47423456789', 'William Reis'),
  648. ('47523456789', 'Xavier Rocha'),
  649. ('47623456789', 'Yuri Lima'),
  650. ('47723456789', 'Zoe Alves'),
  651. ('47823456789', 'Alice Martins'),
  652. ('47923456789', 'Bruno Duarte'),
  653. ('48023456789', 'Camila Castro'),
  654. ('48123456789', 'Daniel Ferreira'),
  655. ('48223456789', 'Emília Mendes'),
  656. ('48323456789', 'Fábio Correia'),
  657. ('48423456789', 'Giulia Costa'),
  658. ('48523456789', 'Henrique Gomes'),
  659. ('48623456789', 'Isabela Ribeiro'),
  660. ('48723456789', 'João Pinto'),
  661. ('48823456789', 'Karla Rocha'),
  662. ('48923456789', 'Luís Teixeira'),
  663. ('49023456789', 'Marina Vieira'),
  664. ('49123456789', 'Nicole Almeida'),
  665. ('49223456789', 'Otávio Moreira'),
  666. ('49323456789', 'Paula Barros'),
  667. ('49423456789', 'Renato Brito'),
  668. ('49523456789', 'Sônia Cardoso'),
  669. ('49623456789', 'Tadeu Carvalho'),
  670. ('49723456789', 'Viviane Farias'),
  671. ('49823456789', 'Wagner Souza'),
  672. ('49923456789', 'Ximena Gonçalves'),
  673. ('50023456789', 'Yasmin Reis'),
  674. ('50123456789', 'Zeca Rocha'),
  675. ('50223456789', 'Amanda Lima'),
  676. ('50323456789', 'Bruno Alves'),
  677. ('50423456789', 'Camila Martins'),
  678. ('50523456789', 'Daniel Duarte'),
  679. ('50623456789', 'Emília Castro'),
  680. ('50723456789', 'Fábio Ferreira'),
  681. ('50823456789', 'Giulia Mendes'),
  682. ('50923456789', 'Henrique Correia'),
  683. ('51023456789', 'Isabela Costa'),
  684. ('51123456789', 'João Gomes'),
  685. ('51223456789', 'Karla Ribeiro'),
  686. ('51323456789', 'Luís Pinto'),
  687. ('51423456789', 'Marina Rocha'),
  688. ('51523456789', 'Nicole Teixeira'),
  689. ('51623456789', 'Otávio Vieira'),
  690. ('51723456789', 'Paula Almeida'),
  691. ('51823456789', 'Renato Moreira'),
  692. ('51923456789', 'Sônia Barros'),
  693. ('52023456789', 'Tadeu Brito'),
  694. ('52123456789', 'Viviane Cardoso'),
  695. ('52223456789', 'Wagner Carvalho'),
  696. ('52323456789', 'Ximena Farias'),
  697. ('52423456789', 'Yasmin Souza'),
  698. ('52523456789', 'Zeca Gonçalves'),
  699. ('52623456789', 'Amanda Reis'),
  700. ('52723456789', 'Bruno Rocha'),
  701. ('52823456789', 'Carlos Lima'),
  702. ('52923456789', 'Diana Alves'),
  703. ('53023456789', 'Eduardo Martins'),
  704. ('53123456789', 'Fernanda Duarte'),
  705. ('53223456789', 'Gabriel Castro'),
  706. ('53323456789', 'Helena Ferreira'),
  707. ('53423456789', 'Igor Mendes'),
  708. ('53523456789', 'Juliana Correia'),
  709. ('53623456789', 'Kaio Costa'),
  710. ('53723456789', 'Larissa Gomes'),
  711. ('53823456789', 'Marcos Ribeiro'),
  712. ('53923456789', 'Natália Pinto'),
  713. ('54023456789', 'Otávio Rocha'),
  714. ('54123456789', 'Patrícia Teixeira'),
  715. ('54223456789', 'Ricardo Vieira'),
  716. ('54323456789', 'Simone Almeida'),
  717. ('54423456789', 'Tadeu Moreira'),
  718. ('54523456789', 'Viviane Barros'),
  719. ('54623456789', 'William Brito'),
  720. ('54723456789', 'Xavier Cardoso'),
  721. ('54823456789', 'Yuri Carvalho'),
  722. ('54923456789', 'Zoe Farias'),
  723. ('55023456789', 'Alice Souza'),
  724. ('55123456789', 'Bruno Gonçalves'),
  725. ('55223456789', 'Camila Reis'),
  726. ('55323456789', 'Daniel Rocha'),
  727. ('55423456789', 'Emília Lima'),
  728. ('55523456789', 'Fábio Alves'),
  729. ('55623456789', 'Giulia Martins'),
  730. ('55723456789', 'Henrique Duarte'),
  731. ('55823456789', 'Isabela Castro'),
  732. ('55923456789', 'João Ferreira'),
  733. ('56023456789', 'Karla Mendes'),
  734. ('56123456789', 'Luís Correia'),
  735. ('56223456789', 'Marina Costa'),
  736. ('56323456789', 'Nicole Gomes'),
  737. ('56423456789', 'Otávio Ribeiro'),
  738. ('56523456789', 'Paula Pinto'),
  739. ('56623456789', 'Renato Rocha'),
  740. ('56723456789', 'Sônia Teixeira'),
  741. ('56823456789', 'Tadeu Vieira'),
  742. ('56923456789', 'Viviane Almeida'),
  743. ('57023456789', 'Wagner Moreira'),
  744. ('57123456789', 'Ximena Barros'),
  745. ('57223456789', 'Yasmin Brito'),
  746. ('57323456789', 'Zeca Cardoso'),
  747. ('57423456789', 'Amanda Carvalho'),
  748. ('57523456789', 'Bruno Farias'),
  749. ('57623456789', 'Carlos Souza'),
  750. ('57723456789', 'Diana Gonçalves'),
  751. ('57823456789', 'Eduardo Reis'),
  752. ('57923456789', 'Fernanda Rocha'),
  753. ('58023456789', 'Gabriel Lima'),
  754. ('58123456789', 'Helena Alves'),
  755. ('58223456789', 'Igor Martins'),
  756. ('58323456789', 'Juliana Duarte'),
  757. ('58423456789', 'Kaio Castro'),
  758. ('58523456789', 'Larissa Ferreira'),
  759. ('58623456789', 'Marcos Mendes'),
  760. ('58723456789', 'Natália Correia'),
  761. ('58823456789', 'Otávio Costa'),
  762. ('58923456789', 'Patrícia Gomes'),
  763. ('59023456789', 'Ricardo Ribeiro'),
  764. ('59123456789', 'Simone Pinto'),
  765. ('59223456789', 'Tadeu Rocha'),
  766. ('59323456789', 'Viviane Teixeira'),
  767. ('59423456789', 'William Vieira'),
  768. ('59523456789', 'Xavier Almeida'),
  769. ('59623456789', 'Yuri Moreira'),
  770. ('59723456789', 'Zoe Barros'),
  771. ('59823456789', 'Alice Brito'),
  772. ('59923456789', 'Bruno Cardoso'),
  773. ('60023456789', 'Camila Carvalho'),
  774. ('60123456789', 'Daniel Farias'),
  775. ('60223456789', 'Emília Souza'),
  776. ('60323456789', 'Fábio Gonçalves'),
  777. ('60423456789', 'Giulia Reis'),
  778. ('60523456789', 'Henrique Rocha'),
  779. ('60623456789', 'Isabela Lima'),
  780. ('60723456789', 'João Alves'),
  781. ('60823456789', 'Karla Martins'),
  782. ('60923456789', 'Luís Duarte'),
  783. ('61023456789', 'Marina Castro'),
  784. ('61123456789', 'Nicole Ferreira'),
  785. ('61223456789', 'Otávio Mendes'),
  786. ('61323456789', 'Paula Correia'),
  787. ('61423456789', 'Renato Costa'),
  788. ('61523456789', 'Sônia Gomes'),
  789. ('61623456789', 'Tadeu Ribeiro'),
  790. ('61723456789', 'Viviane Pinto'),
  791. ('61823456789', 'Wagner Rocha'),
  792. ('61923456789', 'Ximena Teixeira'),
  793. ('62023456789', 'Yasmin Vieira'),
  794. ('62123456789', 'Zeca Almeida'),
  795. ('62223456789', 'Amanda Moreira'),
  796. ('62323456789', 'Bruno Barros'),
  797. ('62423456789', 'Carlos Brito'),
  798. ('62523456789', 'Diana Cardoso'),
  799. ('62623456789', 'Eduardo Carvalho'),
  800. ('62723456789', 'Fernanda Farias'),
  801. ('62823456789', 'Gabriel Souza'),
  802. ('62923456789', 'Helena Gonçalves'),
  803. ('63023456789', 'Igor Reis'),
  804. ('63123456789', 'Juliana Rocha'),
  805. ('63223456789', 'Kaio Lima'),
  806. ('63323456789', 'Larissa Alves'),
  807. ('63423456789', 'Marcos Martins'),
  808. ('63523456789', 'Natália Duarte'),
  809. ('63623456789', 'Otávio Castro'),
  810. ('63723456789', 'Patrícia Ferreira'),
  811. ('63823456789', 'Ricardo Mendes'),
  812. ('63923456789', 'Simone Correia'),
  813. ('64023456789', 'Tadeu Costa'),
  814. ('64123456789', 'Viviane Gomes'),
  815. ('64223456789', 'William Ribeiro'),
  816. ('64323456789', 'Xavier Pinto'),
  817. ('64423456789', 'Yuri Rocha'),
  818. ('64523456789', 'Zoe Teixeira'),
  819. ('64623456789', 'Alice Vieira'),
  820. ('64723456789', 'Bruno Almeida'),
  821. ('64823456789', 'Camila Moreira'),
  822. ('64923456789', 'Daniel Barros'),
  823. ('65023456789', 'Emília Brito'),
  824. ('65123456789', 'Fábio Cardoso'),
  825. ('65223456789', 'Giulia Carvalho'),
  826. ('65323456789', 'Henrique Farias'),
  827. ('65423456789', 'Isabela Souza'),
  828. ('65523456789', 'João Gonçalves'),
  829. ('65623456789', 'Karla Reis'),
  830. ('65723456789', 'Luís Rocha'),
  831. ('65823456789', 'Marina Lima'),
  832. ('65923456789', 'Nicole Alves'),
  833. ('66023456789', 'Otávio Martins'),
  834. ('66123456789', 'Paula Duarte'),
  835. ('66223456789', 'Renato Castro'),
  836. ('66323456789', 'Sônia Ferreira'),
  837. ('66423456789', 'Tadeu Mendes'),
  838. ('66523456789', 'Viviane Correia'),
  839. ('66623456789', 'Wagner Costa'),
  840. ('66723456789', 'Ximena Gomes'),
  841. ('66823456789', 'Yasmin Ribeiro'),
  842. ('66923456789', 'Zeca Pinto'),
  843. ('67023456789', 'Amanda Rocha'),
  844. ('67123456789', 'Bruno Teixeira'),
  845. ('67223456789', 'Carlos Vieira'),
  846. ('67323456789', 'Diana Almeida'),
  847. ('67423456789', 'Eduardo Moreira'),
  848. ('67523456789', 'Fernanda Barros'),
  849. ('67623456789', 'Gabriel Brito'),
  850. ('67723456789', 'Helena Cardoso'),
  851. ('67823456789', 'Igor Carvalho'),
  852. ('67923456789', 'Juliana Farias'),
  853. ('68023456789', 'Kaio Souza'),
  854. ('68123456789', 'Larissa Gonçalves'),
  855. ('68223456789', 'Marcos Reis'),
  856. ('68323456789', 'Natália Rocha'),
  857. ('68423456789', 'Otávio Lima'),
  858. ('68523456789', 'Patrícia Alves'),
  859. ('68623456789', 'Ricardo Martins'),
  860. ('68723456789', 'Simone Duarte'),
  861. ('68823456789', 'Tadeu Castro'),
  862. ('68923456789', 'Viviane Ferreira'),
  863. ('69023456789', 'William Mendes'),
  864. ('69123456789', 'Xavier Correia'),
  865. ('69223456789', 'Yuri Costa'),
  866. ('69323456789', 'Zoe Gomes'),
  867. ('69423456789', 'Alice Ribeiro'),
  868. ('69523456789', 'Bruno Pinto'),
  869. ('69623456789', 'Camila Rocha'),
  870. ('69723456789', 'Daniel Teixeira'),
  871. ('69823456789', 'Emília Vieira'),
  872. ('69923456789', 'Fábio Almeida'),
  873. ('70023456789', 'Giulia Moreira'),
  874. ('70123456789', 'Henrique Barros'),
  875. ('70223456789', 'Isabela Brito'),
  876. ('70323456789', 'João Cardoso'),
  877. ('70423456789', 'Karla Carvalho'),
  878. ('70523456789', 'Luís Farias'),
  879. ('70623456789', 'Marina Souza'),
  880. ('70723456789', 'Nicole Gonçalves'),
  881. ('70823456789', 'Otávio Reis'),
  882. ('70923456789', 'Paula Rocha'),
  883. ('71023456789', 'Renato Lima'),
  884. ('71123456789', 'Sônia Alves'),
  885. ('71223456789', 'Tadeu Martins'),
  886. ('71323456789', 'Viviane Duarte'),
  887. ('71423456789', 'Wagner Castro'),
  888. ('71523456789', 'Ximena Ferreira'),
  889. ('71623456789', 'Yasmin Mendes');
  890.  
  891.  
  892. INSERT INTO filmes.Filme (idFilme, filmeNome, ano, genero)
  893. VALUES
  894. (26, 'The Shawshank Redemption', 1994, 'Drama'),
  895. (27, 'The Godfather', 1972, 'Crime'),
  896. (28, 'The Dark Knight', 2008, 'Ação'),
  897. (29, 'Interstellar', 2014, 'Ficção'),
  898. (30, 'Schindler''s List', 1993, 'Biografia'),
  899. (31, 'The Silence of the Lambs', 1991, 'Crime'),
  900. (32, 'The Green Mile', 1999, 'Drama'),
  901. (33, 'Gladiator', 2000, 'Ação'),
  902. (34, 'The Departed', 2006, 'Crime'),
  903. (35, 'The Prestige', 2006, 'Drama'),
  904. (36, 'Saving Private Ryan', 1998, 'Guerra'),
  905. (37, 'The Matrix Reloaded', 2003, 'Ficção'),
  906. (38, 'The Matrix Revolutions', 2003, 'Ficção'),
  907. (39, 'Inglourious Basterds', 2009, 'Ação'),
  908. (40, 'The Lion King', 1994, 'Animação'),
  909. (41, 'The Usual Suspects', 1995, 'Crime'),
  910. (42, 'The Sixth Sense', 1999, 'Drama'),
  911. (43, 'Se7en', 1995, 'Crime'),
  912. (44, 'The Truman Show', 1998, 'Drama'),
  913. (45, 'The Social Network', 2010, 'Biografia'),
  914. (46, 'The Revenant', 2015, 'Aventura'),
  915. (47, 'Forrest Gump', 1994, 'Romance'),
  916. (48, 'American Beauty', 1999, 'Drama'),
  917. (49, 'Titanic', 1997, 'Romance'),
  918. (50, 'The Big Lebowski', 1998, 'Comédia'),
  919. (51, 'American History X', 1998, 'Drama'),
  920. (52, 'Pulp Fiction', 1994, 'Crime'),
  921. (53, 'Fight Club', 1999, 'Drama'),
  922. (54, 'The Lord of the Rings 1', 2001, 'Aventura'),
  923. (55, 'The Lord of the Rings 2', 2002, 'Aventura'),
  924. (56, 'The Lord of the Rings 3', 2003, 'Aventura'),
  925. (57, 'Forrest Gump', 1994, 'Romance'),
  926. (58, 'American Beauty', 1999, 'Drama'),
  927. (59, 'Titanic', 1997, 'Romance'),
  928. (60, 'The Big Lebowski', 1998, 'Comédia'),
  929. (61, 'American History X', 1998, 'Drama'),
  930. (62, 'The Shawshank Redemption', 1994, 'Ação'),
  931. (63, 'The Godfather', 1972, 'Drama'),
  932. (64, 'The Dark Knight', 2008, 'Crime'),
  933. (65, 'Interstellar', 2014, 'Ficção'),
  934. (66, 'Schindler''s List', 1993, 'Biografia'),
  935. (67, 'The Silence of the Lambs', 1991, 'Crime'),
  936. (68, 'The Green Mile', 1999, 'Drama'),
  937. (69, 'Gladiator', 2000, 'Ação'),
  938. (70, 'The Departed', 2006, 'Crime'),
  939. (71, 'The Prestige', 2006, 'Drama'),
  940. (72, 'Saving Private Ryan', 1998, 'Guerra'),
  941. (73, 'The Matrix Reloaded', 2003, 'Ficção'),
  942. (74, 'The Matrix Revolutions', 2003, 'Ficção'),
  943. (75, 'Inglourious Basterds', 2009, 'Ação'),
  944. (76, 'The Lion King', 1994, 'Animação'),
  945. (77, 'The Usual Suspects', 1995, 'Crime'),
  946. (78, 'The Sixth Sense', 1999, 'Drama'),
  947. (79, 'Se7en', 1995, 'Crime'),
  948. (80, 'The Truman Show', 1998, 'Drama'),
  949. (81, 'The Social Network', 2010, 'Biografia'),
  950. (82, 'The Revenant', 2015, 'Aventura'),
  951. (83, 'Forrest Gump', 1994, 'Romance'),
  952. (84, 'American Beauty', 1999, 'Drama'),
  953. (85, 'Titanic', 1997, 'Romance'),
  954. (86, 'The Big Lebowski', 1998, 'Comédia'),
  955. (87, 'American History X', 1998, 'Drama'),
  956. (88, 'The Shawshank Redemption', 1994, 'Ação'),
  957. (89, 'The Godfather', 1972, 'Drama'),
  958. (90, 'The Dark Knight', 2008, 'Crime'),
  959. (91, 'Interstellar', 2014, 'Ficção'),
  960. (92, 'Schindler''s List', 1993, 'Biografia');
  961.  
  962.  
  963.  
  964. INSERT INTO Filme (idFilme, filmeNome, ano, genero)
  965. VALUES
  966. (93, 'Warrior', 2011, 'Luta'),
  967. (94, 'Rocky', 1976, 'Luta'),
  968. (95, 'Creed', 2015, 'Luta'),
  969. (96, 'Fight Club', 1999, 'Luta'),
  970. (97, 'Undisputed', 2002, 'Luta'),
  971. (98, 'Never Back Down', 2008, 'Luta'),
  972. (99, 'Bloodsport', 1988, 'Luta'),
  973. (100, 'Enter the Dragon', 1973, 'Luta'),
  974. (101, 'The Fighter', 2010, 'Luta'),
  975. (102, 'Raging Bull', 1980, 'Luta'),
  976. (103, 'Kickboxer', 1989, 'Luta'),
  977. (104, 'The Karate Kid', 1984, 'Luta'),
  978. (105, 'Ip Man', 2008, 'Luta'),
  979. (106, 'The Raid: Redemption', 2011, 'Luta'),
  980. (107, 'Ong-Bak: Muay Thai Warrior', 2003, 'Luta'),
  981. (108, 'Kill Bill: Vol. 1', 2003, 'Luta'),
  982. (109, 'Kill Bill: Vol. 2', 2004, 'Luta'),
  983. (110, 'The Street Fighter', 1974, 'Luta'),
  984. (111, 'Bloodsport II: The Next Kumite', 1996, 'Luta'),
  985. (112, 'Never Back Down 2: The Beatdown', 2011, 'Luta'),
  986. (113, 'Bloodsport III', 1997, 'Luta'),
  987. (114, 'The Karate Kid Part II', 1986, 'Luta'),
  988. (115, 'Kickboxer 2: The Road Back', 1991, 'Luta'),
  989. (116, 'The Raid 2', 2014, 'Luta'),
  990. (117, 'Ip Man 2', 2010, 'Luta'),
  991. (118, 'Rocky II', 1979, 'Luta'),
  992. (119, 'Warrior King', 2005, 'Luta'),
  993. (120, 'The Way of the Dragon', 1972, 'Luta'),
  994. (121, 'Undisputed II: Last Man Standing', 2006, 'Luta'),
  995. (122, 'Fist of Fury', 1972, 'Luta'),
  996. (123, 'The Legend of Drunken Master', 1994, 'Luta'),
  997. (124, 'Creed II', 2018, 'Luta'),
  998. (125, 'Rocky III', 1982, 'Luta'),
  999. (126, 'Rocky IV', 1985, 'Luta'),
  1000. (127, 'The Quest', 1996, 'Luta'),
  1001. (128, 'Bloodsport 4: The Dark Kumite', 1999, 'Luta'),
  1002. (129, 'Never Back Down: No Surrender', 2016, 'Luta'),
  1003. (130, 'Best of the Best', 1989, 'Luta'),
  1004. (131, 'The Karate Kid Part III', 1989, 'Luta'),
  1005. (132, 'Kickboxer 3', 1992, 'Luta'),
  1006. (133, 'Ip Man 3', 2015, 'Luta'),
  1007. (134, 'Kickboxer 4: The Aggressor', 1994, 'Luta'),
  1008. (135, 'Rocky Balboa', 2006, 'Luta'),
  1009. (136, 'Kickboxer: Retaliation', 2018, 'Luta'),
  1010. (137, 'The Karate Kid Part III', 1989, 'Luta');
  1011.  
  1012.  
  1013.  
  1014.  
  1015.  
  1016.  
  1017.  
  1018.  
  1019.  
  1020.  
  1021. INSERT INTO filmes.Ator (idAtor, idFilmeA, atorNome)
  1022. VALUES
  1023. -- Atores de "Warrior"
  1024. (76, 93, 'Tom Hardy'),
  1025. (77, 93, 'Joel Edgerton'),
  1026. (78, 93, 'Nick Nolte'),
  1027.  
  1028. -- Atores de "Rocky"
  1029. (79, 94, 'Sylvester Stallone'),
  1030. (80, 94, 'Talia Shire'),
  1031. (81, 94, 'Burt Young'),
  1032.  
  1033. -- Atores de "Creed"
  1034. (82, 95, 'Michael B. Jordan'),
  1035. (83, 95, 'Sylvester Stallone'),
  1036. (84, 95, 'Tessa Thompson'),
  1037.  
  1038. -- Atores de "Fight Club"
  1039. (85, 96, 'Edward Norton'),
  1040. (86, 96, 'Brad Pitt'),
  1041. (87, 96, 'Helena Bonham Carter'),
  1042.  
  1043. -- Atores de "Undisputed"
  1044. (88, 97, 'Wesley Snipes'),
  1045. (89, 97, 'Ving Rhames'),
  1046. (90, 97, 'Peter Falk'),
  1047.  
  1048. -- Atores de "Never Back Down"
  1049. (91, 98, 'Sean Faris'),
  1050. (92, 98, 'Amber Heard'),
  1051. (93, 98, 'Cam Gigandet'),
  1052.  
  1053. -- Atores de "Bloodsport"
  1054. (94, 99, 'Jean-Claude Van Damme'),
  1055. (95, 99, 'Donald Gibb'),
  1056. (96, 99, 'Leah Ayres'),
  1057.  
  1058. -- Atores de "Enter the Dragon"
  1059. (97, 100, 'Bruce Lee'),
  1060. (98, 100, 'John Saxon'),
  1061. (99, 100, 'Jim Kelly'),
  1062.  
  1063. -- Atores de "The Fighter"
  1064. (100, 101, 'Mark Wahlberg'),
  1065. (101, 101, 'Christian Bale'),
  1066. (102, 101, 'Amy Adams'),
  1067.  
  1068. -- Atores de "Raging Bull"
  1069. (103, 102, 'Robert De Niro'),
  1070. (104, 102, 'Joe Pesci'),
  1071. (105, 102, 'Cathy Moriarty'),
  1072.  
  1073. -- Atores de "Kickboxer"
  1074. (106, 103, 'Jean-Claude Van Damme'),
  1075. (107, 103, 'Dennis Alexio'),
  1076. (108, 103, 'Dennis Chan'),
  1077.  
  1078. -- Atores de "The Karate Kid"
  1079. (109, 104, 'Ralph Macchio'),
  1080. (110, 104, 'Pat Morita'),
  1081. (111, 104, 'Elisabeth Shue'),
  1082.  
  1083. -- Atores de "Ip Man"
  1084. (112, 105, 'Donnie Yen'),
  1085. (113, 105, 'Simon Yam'),
  1086. (114, 105, 'Lynn Hung'),
  1087.  
  1088. -- Atores de "The Raid: Redemption"
  1089. (115, 106, 'Iko Uwais'),
  1090. (116, 106, 'Yayan Ruhian'),
  1091. (117, 106, 'Arifin Putra'),
  1092.  
  1093. -- Atores de "Ong-Bak: Muay Thai Warrior"
  1094. (118, 107, 'Tony Jaa'),
  1095. (119, 107, 'Petchtai Wongkamlao'),
  1096. (120, 107, 'Pumwaree Yodkamol'),
  1097.  
  1098. -- Atores de "Kill Bill: Vol. 1"
  1099. (121, 108, 'Uma Thurman'),
  1100. (122, 108, 'David Carradine'),
  1101. (123, 108, 'Lucy Liu'),
  1102.  
  1103. -- Atores de "Kill Bill: Vol. 2"
  1104. (124, 109, 'Uma Thurman'),
  1105. (125, 109, 'David Carradine'),
  1106. (126, 109, 'Michael Madsen'),
  1107.  
  1108. -- Atores de "The Street Fighter"
  1109. (127, 110, 'Sonny Chiba'),
  1110. (128, 110, 'Etsuko Shihomi'),
  1111. (129, 110, 'Goichi Yamada'),
  1112.  
  1113. -- Atores de "Bloodsport II: The Next Kumite"
  1114. (130, 111, 'Daniel Bernhardt'),
  1115. (131, 111, 'Stefanos Miltsakakis'),
  1116. (132, 111, 'Nicholas Guest'),
  1117.  
  1118. -- Atores de "Never Back Down 2: The Beatdown"
  1119. (133, 112, 'Michael Jai White'),
  1120. (134, 112, 'Dean Geyer'),
  1121. (135, 112, 'Alex Meraz'),
  1122.  
  1123. -- Atores de "Bloodsport III"
  1124. (136, 113, 'Daniel Bernhardt'),
  1125. (137, 113, 'John Rhys-Davies'),
  1126. (138, 113, 'Amber Van Lent'),
  1127.  
  1128. -- Atores de "The Karate Kid Part II"
  1129. (139, 114, 'Ralph Macchio'),
  1130. (140, 114, 'Pat Morita'),
  1131. (141, 114, 'Nobu McCarthy'),
  1132.  
  1133. -- Atores de "Kickboxer 2: The Road Back"
  1134. (142, 115, 'Sasha Mitchell'),
  1135. (143, 115, 'Peter Boyle'),
  1136. (144, 115, 'Dennis Chan'),
  1137.  
  1138. -- Atores de "The Raid 2"
  1139. (145, 116, 'Iko Uwais'),
  1140. (146, 116, 'Yayan Ruhian'),
  1141. (147, 116, 'Arifin Putra'),
  1142.  
  1143. -- Atores de "Ip Man 2"
  1144. (148, 117, 'Donnie Yen'),
  1145. (149, 117, 'Lynn Hung'),
  1146. (150, 117, 'Simon Yam'),
  1147.  
  1148. -- Atores de "Rocky II"
  1149. (151, 118, 'Sylvester Stallone'),
  1150. (152, 118, 'Talia Shire'),
  1151. (153, 118, 'Burt Young');
  1152.  
  1153.  
  1154.  
  1155.  
  1156.  
  1157.  
  1158.  
  1159.  
  1160.  
  1161.  
  1162.  
  1163.  
  1164. INSERT INTO Critica (idFilme, cpfCliente, nota, argumentos, data) VALUES
  1165. (2, '23456789012', 7, 'Good movie.', '2023-05-18'),
  1166. (3, '34567890123', 9, 'Excellent!', '2023-05-18'),
  1167. (4, '45678901234', 6, 'Pretty good.', '2023-05-18'),
  1168. (5, '56789012345', 5, 'Not bad.', '2023-05-18'),
  1169. (6, '67890123456', 4, 'Could be better.', '2023-05-18'),
  1170. (7, '78901234567', 3, 'Not great.', '2023-05-18'),
  1171. (8, '89012345678', 10, 'Masterpiece!', '2023-05-18'),
  1172. (9, '90123456789', 2, 'Poor movie.', '2023-05-18'),
  1173. (10, '01234567890', 1, 'Terrible.', '2023-05-18'),
  1174. (11, '11234567890', 7, 'Nice film.', '2023-05-18'),
  1175. (12, '21234567890', 8, 'Enjoyed it.', '2023-05-18'),
  1176. (13, '31234567890', 6, 'It was okay.', '2023-05-18'),
  1177. (14, '41234567890', 5, 'Average.', '2023-05-18'),
  1178. (15, '51234567890', 4, 'Could be better.', '2023-05-18'),
  1179. (16, '61234567890', 3, 'Disappointed.', '2023-05-18'),
  1180. (17, '71234567890', 2, 'Not worth it.', '2023-05-18'),
  1181. (18, '81234567890', 9, 'Fantastic!', '2023-05-18'),
  1182. (19, '91234567890', 1, 'Very bad.', '2023-05-18'),
  1183. (21, '20234567890', 7, 'Good enough.', '2023-05-18'),
  1184. (22, '30234567890', 6, 'Okayish.', '2023-05-18'),
  1185. (23, '40234567890', 5, 'Mediocre.', '2023-05-18'),
  1186. (24, '50234567890', 8, 'Pretty good.', '2023-05-18'),
  1187. (25, '60234567890', 9, 'Awesome!', '2023-05-18'),
  1188. (26, '70234567890', 4, 'Not my taste.', '2023-05-18'),
  1189. (27, '80234567890', 3, 'Boring.', '2023-05-18'),
  1190. (28, '90234567890', 2, 'Awful.', '2023-05-18');
  1191.  
  1192.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement