CREATE TABLE Film ( FNr INTEGER NOT NULL, Title VARCHAR(100), Year SMALLINT, Country VARCHAR(50), Genre VARCHAR(50), age SMALLINT, Time SMALLINT, Price DECIMAL(8, 2), CONSTRAINT FilmPN PRIMARY KEY (FNr) );

INSERT INTO Film (FNr, Title, year, country, Genre, Age, Time, Price) VALUES ( 1, 'Casablanca', 1942, 'USA', 'Drama', 15, 102, '149.00'), ( 2, 'Fort Apachea', 1948, 'USA', 'Western', 15, 127, NULL), ( 3, 'Apocalypse Now', 1979, 'USA', 'Action', 18, 155, '123.00'), ( 4, 'Streets of Fire', 1984, 'USA', 'Action', 15, 93, NULL), ( 5, 'High Noon', 1952, 'USA', 'Western', 15, 85, '123.00'), ( 6, 'Cinema Paradiso', 1988, 'Italia', 'Komedie', 11, 123, NULL), ( 7, 'Asterix hos britene', 1988, 'Frankrike', 'Tegnefilm', 7, 78, '149.00'), ( 8, 'Veiviseren', 1987, 'Norge', 'Action', 15, 96, '87.00'), ( 9, 'Salmer fra kjkkenet', 2002, 'Norge', 'Komedie', 7, 80, '149.00'), (10, 'Anastasia', 1997, 'USA', 'Tegnefilm', 7, 94, '123.00'), (11, 'La Grande bouffe', 1973, 'Frankrike', 'Drama', 15, 129, ' 87.00'), (12, 'The Blues Brothers', 1980, 'USA', 'Komedie', 11, 124, '135.00'), (13, 'Beatles: Help', 1965, 'Storbritania', 'Musikk', 11, 144, NULL);

download this file and run it in Worbench.

Then perform the following queries against this file:

Title of American films produced in the 1980s Comedies with an age limit of less than 10 years and a playing time of less than 130 minutes. Title of all action and western films. All production countries, sorted and without repetitions. Movies with titles ending in 'now'.