Using BETWEEN
Let's use BETWEEN
with AND
on the films database to get the title
and release_year
of all Spanish-language films released between 1990 and 2000 (inclusive) with budgets over $100 million.
We have broken the problem into smaller steps so that you can build the query as you go along!
This exercise is part of the course
Intermediate SQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Select the title and release_year for films released between 1990 and 2000
___