Basic Filtering with Sakila
Basic Filtering with Sakila Data Science Project
Beginning SQL: Basic Selection Statements

Basic Filtering with Sakila

In this project, you will have the opportunity to practice working with WHERE clauses and ORDER BY statements in SQL.
Start this project
Basic Filtering with SakilaBasic Filtering with Sakila
Project Created by

Maria Lucila Ferreira

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 email of customer number 135?

Write a query that returns the email of the customer with customer_id equals to 135 from customer table in the sakila database.

Choose the correct answer:

multiplechoice

What's the category which id is 8?

Write a query that returns the name of the category with category_id equals to 8 from category table in the sakila database.

Choose the correct answer:

multiplechoice

What's the name of the employee number 2?

Write a query that returns the first name of the employee with staff_id equals to 2 from staff table in the sakila database.

Please select the correct answer:

multiplechoice

Is there any other employee appart from Jon? If yes, what's his name?

Write a query that returns the first name of the employee that is not Jon from staff table in the sakila database and then select the correct answer:

multiplechoice

Are there any movies which rental cost is higher than `$5`?

In the film table of the sakila database, are there any movies which rental cost is higher than $5? Please select the correct answer:

multiplechoice

Are there any movies which were released before 2006?

In the film table of the sakila database, are there any movies which were released before 2006? Please select the correct answer:

multiplechoice

What is the id of the first rental of year 2006?

Table rental in the sakila database contains all the rentals that have been made in the store. What is the id of the first rental of year 2006? Please select the correct answer:

multiplechoice

What's the name of the actor which last name is LOLLOBRIGIDA?

In the actor table of the sakila database, what's the name of the actor which last name is LOLLOBRIGIDA? Please select the correct answer:

multiplechoice

Which is the first movie which replacement cost is equal or higher than `$20`, when ordered alphabetically?

In the film table of the sakila database, which is the first movie which replacement cost is equal or higher than $20, when ordered alphabetically? Please select the correct answer:

multiplechoice

What movie has a rental duration lower than 4 days and the lowest film id?

In the film table of the sakila database, what movie has a rental duration lower than 4 days and the lowest film id? Please select the correct answer:

multiplechoice

What's the rental rate of the shortest movie that is longer than 2 hours?

In the film table of the sakila database, what's the rental rate of the shortest movie that is longer than 2 hours? Please select the correct answer:

codevalidated

Display the title and rental rate of all movies that have a rental rate of less than `$1.50`

Wite a SQL query that displays the title and rental rate of all movies that have a rental rate of less than $1.50 per day. Your results should look something like:

codevalidated

Display the title and length of all movies that have a length of more than 2 hours.

Wite a SQL query that displays the title and length of all movies that have a length of more than 2 hours. Your result should look something like:

Basic Filtering with SakilaBasic Filtering with Sakila
Project Created by

Maria Lucila Ferreira

This project is part of

Beginning SQL: Basic Selection Statements

Explore other projects