Project 10: Real Estate Price Filter
SQL Architect
Builds on these lessons
Query Task
Objective
Comparison operators — <, >, <=, >=, <>, = — let a WHERE clause filter on numbers and dates, not just exact text matches.
You're given a listings table with columns id, address, price, and beds.
Task: write a query that returns every column, for rows where price is less than 500000.
query.sql
SELECT * FROM listings WHERE price < 500000;
* Hint: Correct characters turn green, incorrect ones turn red.
Query Results
🗄️
Execute your query to see results