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 SQL query that selects the columns payment_id and customer_idfrom the table payment where the rental_id column is empty.
Query results will look like this
Write a SQL query that selects the columns last_name and actor_idfrom the table actor where the actors' first_name starts with JO.
Query results will look like this
Write a SQL query that selects the column title from the table film_text where the description column includes the term Saga.
Query results will look like this
Write a SQL query that selects the column city from the table city where the second letter is k.
Query results will look like this
Write a SQL query that returns the rental_id, customer_id and return_date of the first 10 rentals on the last 3 days of May 2005 (29 May 2005, 30 May 2005 and 31 May 2005).
Query results will look like this
Write a SQL query that returns the title and release_year of all the films with film_id between 90 and 99.
Query results will look like this
Write a SQL query that returns the first_name, last_name and email, ordering the last name alphabetically, of all the customers in which first_name is DORA, JAMES or MARTHA.
Query results will look like this
