Day 16 · SQL filtering 42 min 30 XP

🔎WHERE: filter rows with conditions

Real tables have thousands of rows and you rarely want them all. WHERE keeps only the rows that match a condition, so the database answers your actual question.

What you'll learn

Create the sample shop database
Filter rows with comparison operators
Combine conditions with AND, OR, IN, BETWEEN and LIKE

A peek inside

Set up the shop database

The rest of Day 16 is a Pro lesson

You're on the free Explorer plan — you get the intro and the video. Go Pro to open the full guided lesson (and all 30 days).

3 deep-dive lessons
A copy-paste worked example
3 hands-on practice tasks
Studio task: Build and question the shop database
3-question quiz, up to 45 XP
4 quick-glance glossary cards
30 XP + streak tracking

Unlock everything — go Pro

Already Pro? Sign in