Question

Which SQL query lists all movies released in the period 1990 to 1999 (inclusive)?

Option 1:
sql
Copy code
SELECT * FROM Movies WHERE release_year BETWEEN 1990 AND 1999;
Option 2:
sql
Copy code
SELECT * FROM Movies WHERE release_year >= 1990 AND release_year <= 1999;
Option 3:
sql
Copy code
SELECT * FROM Movies WHERE release_year IN (1990, 1991, ..., 1999);
Option 4:
sql
Copy code
SELECT * FROM Movies WHERE EXTRACT(YEAR FROM release_date) BETWEEN 1990 AND 1999;

Answer 1

Option 1, 2, 3, and 4 are all valid SQL queries to list movies released from 1990 to 1999, assuming Option 3 includes all the years in the range and Option 4's release_date is the correct date type field to extract the year from.

Step-by-step explanation:

The SQL query that lists all movies released in the period 1990 to 1999 (inclusive) can be any of the following options:

• Option 1: SELECT * FROM Movies WHERE release_year BETWEEN 1990 AND 1999;
• Option 2: SELECT * FROM Movies WHERE release_year >= 1990 AND release_year <= 1999;
• Option 3: SELECT * FROM Movies WHERE release_year IN (1990, 1991, ..., 1999);
• Option 4: SELECT * FROM Movies WHERE EXTRACT(YEAR FROM release_date) BETWEEN 1990 AND 1999;

Options 1 and 2 are equivalent in their result—they will both correctly return all movies released from 1990 to 1999. Option 3 is also correct if it includes all the years from 1990 to 1999 (... indicates the continuum of years). Option 4 is correct assuming release_date is a date type column from which the year can be extracted. All these queries are correctly formulated to include movies released within the specified period.