Project 4: Photo Columns Selector
SQL Architect
Builds on these lessons
Query Task
Objective
Setting up a local environment means installing a real database server (or using a hosted one) and pointing a client at it — the step before you can run any query for real, outside a learning sandbox like this one.
You're given a photos table with columns id, filename, and uploaded_at.
Task: write a query that returns only the id and filename columns, for every row.
query.sql
SELECT id, filename FROM photos;
* Hint: Correct characters turn green, incorrect ones turn red.
Query Results
🗄️
Execute your query to see results