Project 23: Today's Weather Readings
SQL Architect
Builds on these lessons
Query Task
Objective
SQL databases enforce a fixed table schema — every row has the same columns, which is exactly what makes structured, filterable data like daily weather readings a natural fit for a relational table rather than a schema-less NoSQL document store.
You're given a weather_readings table with columns id, city, reading_date, and temp_f.
Task: write a query returning city and temp_f for rows where reading_date equals the current date.
query.sql
SELECT city, temp_f FROM weather_readings WHERE reading_date = CURRENT_DATE;
* Hint: Correct characters turn green, incorrect ones turn red.
Query Results
🗄️
Execute your query to see results