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.
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:
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:
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:
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:
In the film table of the sakila database, are there any movies which rental cost is higher than $5? Please select the correct answer:
In the film table of the sakila database, are there any movies which were released before 2006? Please select the correct answer:
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:
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:
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:
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:
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:
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:
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:
