Refer to the exhibit. A portion of the Movie table from the Movies database is shown. A data analyst is writing a query that will return the title and release date of movies released after 2000. The analyst further needs the list ordered by the release date. Which query will return the required results?
- SELECT Movie
FROM Title, Release_date
WHERE Release_date > '2000-12-31'
ORDER BY Release-date - SELECT Title, Release_date
FROM Release_date > '2000-12-31'
WHERE Movie
ORDER BY Release-date - SELECT Title, Release_date
FROM Movie
WHERE Release_date > '2000-12-31'
ORDER BY Release-date - SELECT Release_date > '2000-12-31'
FROM Title, Release_date
WHERE Movie
ORDER BY Release-date
Explanation: The correct query is:
SELECT Title, Release_date
FROM Movie
WHERE Release_date > '2000-12-31'
ORDER BY Release-date
The SELECT command indicates the columns
The FROM command indicates the table
The WHERE command indicates the criteria
The ORDER command indicates that result is ordered by release date
Related exam: Data Analytics Essentials Course Final Exam
