Project 13: Recent Job Postings

SQL Architect

Builds on these lessons

Query Task

LIMIT caps how many rows come back — combined with ORDER BY, it's how you get "the top N" of something, like the 5 most recently posted jobs.

You're given a jobs table with columns id, title, and posted_at.

Task: write a query that returns every column, sorted by posted_at newest first, limited to the first 5 rows.

query.sql

SELECT * FROM jobs ORDER BY posted_at DESC LIMIT 5;

* Hint: Correct characters turn green, incorrect ones turn red.

Query Results

🗄️

Execute your query to see results