BitWithBite
SQL Worksheet
🗃 Sorting & Limiting Results
SCORE___ / 20
NameClassDate
After this worksheet you can
Sort with ORDER BYASC vs DESCTake top-N with LIMITCombine sort + limit📚 Quick Recap
Without ORDER BY, SQL results come back in an unpredictable order — the database returns rows however it finds them fastest. ORDER BY guarantees a consistent sequence, and LIMIT gives you top-N reports, latest records, and pagination. These two clauses are behind every leaderboard and feed in every app.
🧠 Section A · Concept Check ● BEGINNER 4 × 1 = 4
1Sort results with:
2Highest first uses:
3First 5 rows only:
4Default sort direction is:
🧮 Section B · Problem Solving ● INTERMEDIATE 2 + 3×3 = 11
5ORDER BY price sorts cheapest first.
6ORDER BY score DESC 3 gives the top 3.
7Top 5 most expensive products.
8Alphabetical list of student names.
9Page 2 of results, 10 per page.
🚀 Section C · Challenge ● CHALLENGE 5
10Sort by grade DESC then name ASC.
💭 Reflection — the most useful thing I learned:
A ___/4 B ___/11 C ___/5 Total ___/20
Teacher's Signature
Parent's Signature
✂ answer key — fold or cut before handing out
1-B 2-B 3-A 4-C | 5 ASC 6 LIMIT 7 = SELECT * FROM products ORDER BY price DESC LIMIT 5; 8 = SELECT name FROM students ORDER BY name ASC; 9 = ... LIMIT 10 OFFSET 10; | 10 = ORDER BY grade DESC, name ASC