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 database.

Instructions $\frac{1}{3}$

$35xP$

Select the title and release$\_$year for all German$-$language films released before $2000.$

Update the query from the previous step to show German$-$language films released after $2000$ rather than before.

Select all details for German$-$language films released after $2000$ but before $2010$ using only WHERE and AND $.$