WHERE

🎬 Scenario: Identifying High-Rated Netflix Series#

Your manager at Netflix, Alex, is preparing a report on top-rated shows and wants to filter out lower-performing series.

Alex asks:

Can you retrieve only the shows that have a rating above 8.5? We need to focus on our highest-quality content.

Your job is to query the netflix_series table and provide the requested data.

1. Filtering Data with WHERE#

The WHERE clause filters rows based on specific conditions. Instead of retrieving every record in a table, we can narrow results based on ratings, release years, or genres.

Syntax

SELECT column1, column2
FROM table_name
WHERE condition;

Example Query: Retrieving Top-Rated Series

SELECT title, rating  
FROM netflix_series  
WHERE rating > 8.5;

Output Example

What’s Happening?

• WHERE rating > 8.5 filters the results so that only shows with a rating greater than 8.5 appear.
• The dataset excludes any series with a rating of 8.5 or below.

2. Using Comparison Operators#

We can use different operators to refine our filters:

Example Query: Finding Recent Releases

SELECT title, release_year 
FROM netflix_series 
WHERE release_year >= 2020;

Output Example

3. Filtering with Multiple Conditions#

The AND and OR operators allow us to combine multiple conditions.

• AND: Only returns rows that match all conditions
• OR: Returns rows that match at least one condition

Example Query: Finding High-Rated Shows Released After 2018

SELECT title, rating, release_year 
FROM netflix_series 
WHERE rating > 7.5 AND release_year > 2017;

Output Example

What’s happening?

• AND ensures that both conditions must be true for a row to appear.
• The result excludes any older or lower-rated shows.

Example Query: Finding Either High-Rated or Recent Shows

SELECT title, rating, release_year 
FROM netflix_series 
WHERE rating > 8.5 OR release_year > 2020;

Output Example

✍️ SQL Exercises#

Exercise 1: Filtering High-Rated Netflix Series#

Alex wants a filtered report showing Netflix series that were released in or after 2017 and have a rating of at least 8.0.

Filter conditions:

• release_year >= 2017
• rating >= 8.0

Expected Output Example:

Write an SQL query to return the requested data.

Exercise 2: Identifying Popular Crime and Sci-Fi Series#

Netflix executives want to analyze popular shows in the “Crime” and “Sci-Fi” genres. Your task is to retrieve all Netflix series that belong to either of these genres. Order the table in the ascending order of rating.

Filter conditions:

• genre must be ‘Crime’ or ‘Sci-Fi’.

Expected Output Example:

Write an SQL query to return the requested data.