create table film(
filmid int auto_increment not null primary key,
cim varchar(100) not null,
megjelenes int(4) not null,
mufaj varchar(15) not null,
gyarto varchar(25) not null,
hossz tinyint unsigned not null
);

create table szinesz(
szineszid int auto_increment not null primary key,
nev varchar(30) not null,
szuldatum date not null,
nemzet varchar(10) not null
);

create table szerepek(
id int auto_increment not null primary key,
filmid int not null,
szineszid int not null,
szerep varchar(30) not null,
foreign key (filmid) references film(filmid),
foreign key (szineszid) references szinesz(szineszid)
);

insert into film(cim,megjelenes,mufaj,gyarto,hossz) values
("Barbie",2023,"vígjáték","Warner Bros.",114),
("Az első ember",2018,"filmdráma","Universal Pictures",141),
("Ocean’s Eleven – Tripla vagy semmi",2001,"krimi","Warner Bros.",116),
("Ocean’s Twelve – Eggyel nő a tét",2004, "krimi", "Warner Bros.", 125),
("Michael Clayton",2007,"filmdráma","Warner Bros.",119),
("Mentőexpedíció",2015,"sci-fi","Scott Free Productions",142),
("Titanic",1997,"romantikus","20th Century Fox",194),
("Ne nézz fel!",2021,"vígjáték","Netflix",138),
("Ha eljön Joe Black",1998,"romantikus","Universal Pictures",173),
("Interjú a vámpírral",1994,"horror","Warner Bros.",110),
("A Karib-tenger kalózai: A Fekete Gyöngy átka",2003,"kalandfilm","Walt Disney",137),
("300",2006,"akció","Warner Bros.",117),
("Az operaház fantomja",2004,"musical","Warner Bros.",143),
("Armageddon",1998,"sci-fi","Touchstone Pictures",151),
("Oscar",1991,"vígjáték","Touchstone Pictures",109),
("Ál/Arc",1997,"akció","Parmount Pictures",138),
("A pusztító",1993,"sci-fi","Warner Bros.",115),
("Elfújta a szél",1939,"romantikus","Selznick International",222),
("Fűrész",2004,"horror","Lions Gate Films",103),
("Gladiátor",2000,"akció","Universal Pictures",155),
("Házibuli",1980,"romantikus","Gaumont",110),
("Taxi",1998,"vígjáték","Lions Gate",86),
("Oppenheimer",2023,"thriller","Universal Pictures",180),
("Született gyilkosok",1994,"akció","Warner Bros.",119),
("Ponyvaregény",1994,"thriller","Miramax Films",154),
("Trainspotting",1996,"filmdráma","Channel Four Films",94),
("Top Gun",1986,"akció","Paramount Pictures",110);


insert into szinesz(nev,szuldatum,nemzet) values
("Margot Robbie","1990-07-02","ausztrál"),
("Ryan Gosling","1980-11-12","kanadai"),
("Clarie Foy","1984-04-16","brit"),
("Jason Clarke","1969-07-17","ausztrál"),
("Kyle Chandler","1965-09-17","amerikai"),
("Corey Stoll","1976-03-14","amerikai"),
("George Clooney","1961-05-06","amerikai"),
("Brad Pitt","1963-12-18","amerikai"),
("Matt Damon","1970-10-08","amerikai"),
("Andy García","1956-04-12","kubai"),
("Julia Roberts","1967-10-28","amerikai"),
("Catherine Zeta-Jones","1969-09-25","brit"),
("Tilda Swinton","1960-11-05","brit"),
("Tom Wilkinson","1948-02-05","brit"),
("Sydney Pollack","1934-07-01","amerikai"),
("Jessica Chastain","1977-03-24","amerikai"),
("Jeff Daniels","1955-02-19","amerikai"),
("Kristen Wiig","1973-08-22","amerikai"),
("Leonardo DiCaprio","1974-11-11","amerikai"),
("Kate Winslet","1975-10-05","brit"),
("Jennifer Lawrence","1990-08-15","amerikai"),
("Meryl Streep","1949-06-22","amerikai"),
("Cate Blanchett","1969-05-14","ausztrál"),
("Anthony Hopkins","1937-12-31","brit"),
("Claire Forlani","1971-12-17","brit"),
("Tom Cruise","1962-07-03","amerikai"),
("Antonio Banderas","1958-08-10","spanyol"),
("Johnny Depp","1963-06-09","amerikai"),
("Geoffrey Rush","1951-07-06","ausztrál"),
("Orlando Bloom","1977-01-13","brit"),
("Keira Knightley","1985-03-26","brit"),
("Gerard Butler","1969-11-13","brit"),
("Lena Headey","1973-10-03","brit"),
("David Wenham","1965-09-21","amerikai"),
("Emmy Rossum","1986-09-12","amerikai"),
("Patrick Wilson","1973-07-03","amerikai"),
("Bruce Willis","1955-03-19","amerikai"),
("Liv Tyler","1977-07-01","amerikai"),
("Ben Affleck","1972-08-15","amerikai"),
("Steve Busceni","1957-12-13","amerikai"),
("Sylvester Stallone","1946-07-06","amerikai"),
("Ornella Mutti","1955-03-09","olasz"),
("Nicolas Cage","1964-01-07","amerikai"),
("John Travolta","1954-02-18","amerikai"),
("Wesley Snipes","1962-07-31","amerikai"),
("Sandra Bullock","1964-07-26","amerikai"),
("Vivien Leigh","1913-11-05","angol"),
("Clark Gable","1901-02-01","amerikai"),
("Tobin Bell","1942-08-07","amerikai"),
("Russel Crowe","1964-04-07","ausztrál"),
("Joaquin Phoenix","1974-10-28","amerikai"),
("Sophie Marceau","1966-11-17","francia"),
("Claude Brasseur","1936-06-15","francia"),
("Sami Naceri","1961-07-02","francia"),
("Frederic Diefenthal","1968-07-26","francia"),
("Cillian Murphy","1976-05-25","ír"),
("Florence Pugh","1996-01-03","angol"),
("Woody Harrelson","1961-07-23","amerikai"),
("Juliette Lewis","1973-06-21","amerikai"),
("Samuel L. Jackson","1948-12-21","amerikai"),
("Uma Thurman","1970-04-29","amerikai"),
("Ewan McGregor","1971-03-31","skót"),
("Val Kilmer","1959-12-31","amerikai");


insert into szerepek(filmid,szineszid,szerep) values
(1,1,"Barbie"),
(1,2,"Ken"),
(2,2,"Neil Armstrong"),
(2,3,"Janet Armstrong"),
(2,4,"Ed White"),
(2,5,"Deke Slayton"),
(2,6,"Buzz Aldrin"),
(3,7,"Danny Ocean"),
(4,7,"Danny Ocean"),
(3,8,"Rusty Ryan"),
(4,8,"Rusty Ryan"),
(3,9,"Linus Caldwell"),
(4,9,"Linus Caldwell"),
(3,10,"Terry Benedict"),
(3,11,"Tess Ocean"),
(4,10,"Terry Benedict"),
(4,11,"Tess Ocean"),
(4,12,"Isabel Lahiri"),
(5,7,"Michael Clayton"),
(5,13,"Karen Crowder"),
(5,14,"Arthur Edens"),
(5,15,"Marty Bach"),
(6,9,"Mark Watney"),
(6,16,"Melissa Lewis"),
(6,17,"Teddy Sanders"),
(6,18,"Annie Montrose"),
(7,19,"Jack Dawson"),
(7,20,"Rose Dewitt Bukater"),
(8,19,"Dr. Randall Mindy"),
(8,21,"Kate Dibiasky"),
(8,22,"President Orlean"),
(8,23,"Brie Evantee"),
(9,8,"Joe Black"),
(9,24,"William Parrish"),
(9,25,"Susan Parrish"),
(10,8,"Louis"),
(10,26,"Lestat"),
(10,27,"Armand"),
(11,28,"Jack Sparrow"),
(11,29,"Barbossa"),
(11,30,"Will Turner"),
(11,31,"Elizabeth Swann"),
(12,32,"Leonidas"),
(12,33,"Gorgó királyné"),
(12,34,"Dilios"),
(13,32,"Fantom"),
(13,35,"Christine"),
(13,36,"Raoul"),
(14,37,"Harry S. Stamper"),
(14,38,"Grace Stamper"),
(14,39,"A.J. Frost"),
(14,40,"Rockhound"),
(15,41,"Angelo Provolone"),
(15,42,"Sofia Provolone"),
(16,43,"Castor Troy"),
(16,44,"Sean Archer"),
(17,41,"John Spartan"),
(17,45,"Simon Phoenix"),
(17,46,"Lenina Huxley"),
(18,47,"Scarlett OHara"),
(18,48,"Rhett Butler"),
(19,49,"Jigsaw"),
(20,50,"Maximus Decimus"),
(20,51,"Commodus"),
(21,52,"Vic Beretton"),
(21,53,"Francois Beretton"),
(22,54,"Daniel Morales"),
(22,55,"Emilien Coutant"),
(23,56,"J.Robert Oppenheimer"),
(23,57,"Jean Tatlock"),
(24,58,"Mickey Knox"),
(24,59,"Mallory Knox"),
(25,44,"Vincent Vega"),
(25,60,"Jules Winnfield"),
(25,61,"Mia Wallace"),
(25,37,"Butch Coolidge"),
(26,62,"Mark Renton"),
(27,26,"Pete Mawerick"),
(27,63,"Tom Kazanski");