Using OR
This time you'll write a query to get the title
and release_year
of films released in 1990 or 1999, which were in English or Spanish and took in more than $2,000,000 gross
.
It looks like a lot, but you can build the query up one step at a time to get comfortable with the underlying concept in each step. Let's go!
This exercise is part of the course
Intermediate SQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Find the title and year of films from the 1990 or 1999
___