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

Exercise

Using AND

The following exercises combine AND and OR with the WHERE clause. Using these operators together strengthens your queries and analyses of data.

You will apply these new skills now on the films database.

Instructions 1/3

undefined XP
  • 1
    • Select the title and release_year for all German-language films released before 2000.
  • 2
    • Update the query from the previous step to show German-language films released after 2000 rather than before.
  • 3
    • Select all details for German-language films released after 2000 but before 2010 using only WHERE and AND.