create table films ( title varchar(40), director varchar(40), origin varchar(10), made datetime, length int );
insert into films values ( 'The Fifth Element', 'Luc Besson', 'France', '1997-01-01', 127 );
insert into films values ( 'Aliens', 'James Cameron', 'US', '1986-01-01', 137 );
insert into films values ( 'Alien', 'Ridley Scott', 'UK', '1979-01-01', 117 );
insert into films values ( 'Ben Hur', 'Fred Niblo', 'US', '1925-01-01', 170 );
insert into films values ( 'Ben Hur', 'William Wyler', 'US', '1959-01-01', 217 );
insert into films values ( 'The Birds', 'Alfred Hitchcock', 'US', '1963-01-01', 119 );
insert into films values ( 'Cape Fear', 'J Lee-Thompson', 'US', '1962-01-01', 106 );
insert into films values ( 'Catch 22', 'Mike Nichols', 'US', '1970-01-01', 122 );
insert into films values ( 'Dark Star', 'John Carpenter', 'US', '1974-01-01', 83 );
insert into films values ( 'Battleship Potemkin', 'Sergei Eisenstien', 'USSR', '1925-01-01', 75 );
insert into films values ( 'The Big Sleep', 'Michael Minner', 'UK', '1977-01-01', 99 );
insert into films values ( 'The Terminator', 'James Cameron', 'US', '1984-01-01', 108 );
insert into films values ( 'Alien 3', 'David Fincher', 'US', '1992-01-01', 115 );
insert into films values ( 'Enemy of the State', 'Tony Scott', 'US', '1998-01-01', 131 );
insert into films values ( 'Psycho', 'Gus Van Sant', 'US', '1998-01-01', 109 );
insert into films values ( 'Psycho', 'Alfred Hitchcock', 'US', '1960-01-01', 108 );
insert into films values ( 'The Juror', 'Brian Gibson', 'US', '1996-01-01', 118 );
insert into films values ( 'Crimson Tide', 'Tony Scott', 'US', '1997-01-01', 112 );
insert into films values ( 'Twelve Monkeys', 'Terry Gilliam', 'US', '1995-01-01', 130 );
insert into films values ( 'Alien Resurrection', 'Jean-Pierre Jeunet', 'US', '1997-01-01', 109 );
insert into films values ( 'The Alien', 'Thomas H. Ince', 'US', '1915-01-01', 0 );
insert into films values ( 'Dead Calm', 'Phillip Noyce', 'Australia', '1989-01-01', 95 );
insert into films values ( 'Cape Fear', 'Martin Scorsese', 'US', '1991-01-01', 128 );
