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 Release_date > ‘2000-12-31’
FROM Title, Release_date
WHERE Movie
ORDER BY Release-date - SELECT Title, Release_date
FROM Movie
WHERE Release_date > ‘2000-12-31’
ORDER BY Release-date - 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
| Explanation & Hint:
The correct query is: The SELECT command indicates the columns |