Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
The movies table also includes a release_year column. Some older movies have been re-released in later years, and their titles have been modified to include the re-release year at the end, like "Jaws 1995", "Casablanca 2000".
Write a SQL query to find all movie (ID, Title & Release Year) originally released before the year 1980 but re-released after 2000. Assume the original release year is not part of the title.
Hint: The re-release year is part of the title and follows this format "Casablanca 200" with 2000 the original release year
| movie_id | title | release_year |
|---|---|---|
| 2 | Casablanca 2000 | 1942 |
| 3 | Jaws 2010 | 1978 |
The movies table also includes a release_year column. Some older movies have been re-released in later years, and their titles have been modified to include the re-release year at the end, like "Jaws 1995", "Casablanca 2000".
Write a SQL query to find all movie (ID, Title & Release Year) originally released before the year 1980 but re-released after 2000. Assume the original release year is not part of the title.
Hint: The re-release year is part of the title and follows this format "Casablanca 200" with 2000 the original release year
| movie_id | title | release_year |
|---|---|---|
| 2 | Casablanca 2000 | 1942 |
| 3 | Jaws 2010 | 1978 |