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 Created by

## 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

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:

Project Created by

#### Maria Lucila Ferreira

This project is part of

## Beginning SQL: Basic Selection Statements

Explore other projects