Other SQL Operators (LIKE, IN, IS, BETWEEN)
Other SQL Operators (LIKE, IN, IS, BETWEEN) Data Science Project
Beginning SQL: Basic Selection Statements

Other SQL Operators (LIKE, IN, IS, BETWEEN)

In this project you'll practice other operators using WHERE clause, such as LIKE, IN, IS, BETWEEN. We'll use SQL Database simulating a Video Rental store to apply these operators in meaningful ways, giving you a better understanding of how they work and how to use them effectively.
Start this project
Other SQL Operators (LIKE, IN, IS, BETWEEN)Other SQL Operators (LIKE, IN, IS, BETWEEN)
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.

codevalidated

Checking for null values.

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

codevalidated

Write a query where actors' first name start with `JO`

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

codevalidated

Retrieve films whose descriptions include the term 'Saga'

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

codevalidated

Retrieve the names of all cities where the second letter is `k`

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

codevalidated

Query first 10 Rentals on the Last 3 Days of May 2005

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

codevalidated

Retrieve the titles and release years of films with IDs in the 90s

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

codevalidated

Customer Information Query for Specific Names

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

Other SQL Operators (LIKE, IN, IS, BETWEEN)Other SQL Operators (LIKE, IN, IS, BETWEEN)
Project Created by

Maria Lucila Ferreira

This project is part of

Beginning SQL: Basic Selection Statements

Explore Skill Track
Explore other projects
Set Operations using Sakila
LIKE Operator using World
Membership and Range Operators with World Database