1. Learn
  2. /
  3. Courses
  4. /
  5. Intermediate SQL

Exercise

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!

Instructions 1/4

undefined XP
    1
    2
    3
    4
  • Select the title and release_year of all films released between 1990 and 2000 (inclusive) using BETWEEN.