dsyRQXEX

1
2DROP TABLE IF EXISTS movies_actors;
3
4CREATE TABLE movies_actors
5(
6  year  YEAR NOT NULL,        # year movie was released
7  movie VARCHAR(80) NOT NULL, # movie name
8  actor VARCHAR(60) NOT NULL  # actor name
9);
10
11INSERT INTO movies_actors (year,movie,actor)
12  VALUES
13 (2005,'Kingdom of Heaven','Liam Neeson')
14,(2005,'Kingdom of Heaven','Orlando Bloom')
15,(1997,'The Fifth Element','Bruce Willis')
16,(1997,'The Fifth Element','Gary Oldman')
17,(1997,'The Fifth Element','Ian Holm')
18,(1999,'The Phantom Menace','Ewan McGregor')
19,(1999,'The Phantom Menace','Liam Neeson')
20,(2001,'The Fellowship of the Ring','Ian McKellen')
21,(2001,'The Fellowship of the Ring','Ian Holm')
22,(2001,'The Fellowship of the Ring','Orlando Bloom')
23,(2001,'The Fellowship of the Ring','Elijah Wood')
24,(2010,'Red','Helen Mirren')
25,(2010,'Red','Bruce Willis')
26,(2011,'Unknown','Diane Kruger')
27,(2011,'Unknown','Liam Neeson')
28,(1995,'Twelve Monkeys','Brad Pitt')
29,(1995,'Twelve Monkeys','Bruce Willis')
30,(1995,'Rob Roy','Brian Cox')
31,(1995,'Rob Roy','Liam Neeson')
32,(2005,'Batman Begins','Liam Neeson')
33,(2005,'Batman Begins','Christian Bale')
34,(2000,'X-Men 2','Halle Berry')
35,(2000,'X-Men 2','Hugh Jackman')
36,(2000,'X-Men 2','Ian McKellen')
37,(2000,'X-Men 2','Brian Cox')
38,(2004,'Troy','Brad Pitt')
39,(2004,'Troy','Brian Cox')
40,(2004,'Troy','Diane Kruger')
41,(2004,'Troy','Eric Bana')
42,(2004,'Troy','Orlando Bloom')
43,(2004,'Troy','Sean Bean')
44,(2001,'Swordfish','Halle Berry')
45,(2001,'Swordfish','Hugh Jackman')
46,(2011,'Hanna','Cate Blanchett')
47,(2011,'Hanna','Eric Bana')
48,(2005,'The Island','Ewan McGregor')
49,(2005,'The Island','Michael Clarke Duncan')
50,(2005,'The Island','Sean Bean');