Practice Boolean operators in WHERE with Sakila
Practice Boolean operators in WHERE with Sakila Data Science Project
Beginning SQL: Basic Selection Statements

Practice Boolean operators in WHERE with Sakila

In this project you'll practice more advanced filtering scenarios using WHERE and boolean operators (and, or, etc).

Project Activities

All our Data Science projects include bite-sized activities to test your knowledge and practice in an environment with constant feedback.

All our activities include solutions with explanations on how they work and why we chose them.

multiplechoice

What's the id of the actress *Sandra Kilmer*?

Select the correct id:

multiplechoice

What's the last name of the customer called *Jamie* who's registered in store `2`?

Please select the correct answer:

multiplechoice

Are there any customer that don't have their last name filled in?

Select the correct option.

multiplechoice

Which is the film that lasts between 90 and 120 minutes, which replacement cost is 19.99, rental duration of 5 days and has 'R' rating?

Select the correct option.

multiplechoice

Which are the surnames of the customers called Sara/Sarah?

There are multiple ways of filtering the data, whichever you used, select the correct answer:

multiplechoice

What is the last name of the customer called Terry, but his last name is not Carlson, Cavanagh or Coles?

Please select the correct last name:

multiplechoice

Which is the movie that contains the word 'instinct' in the title and rental rate more than `$4` to rent?

Please select the correct last name:

codevalidated

Find all films with a rating of 'G' and a replacement cost between `$10` and `$20`, inclusive, sorted in descending order

Wite a SQL query that selects all films with a rating of 'G' and a replacement cost between $10 and $20, inclusive, sorted by replacement_cost in descending order. Your query should look something like:

codevalidated

List all films with a rating of 'PG' or 'PG-13' and a replacement cost higher than `$20`, sorted in ascending mode

Wite a SQL query that selects all films with a rating of PG or PG-13 and a replacement cost higher than $20. Order your results by replacement_cost in ascending mode. Your query should look something like:

Practice Boolean operators in WHERE with SakilaPractice Boolean operators in WHERE with Sakila
Author

Maria Lucila Ferreira

This project is part of

Beginning SQL: Basic Selection Statements

Explore other projects