9 · Lesson 4 of 4
SQL: ORDER BY, SUM and COUNT
Syllabus 9.4Syllabus 9.5
What this lesson covers
- Read and complete SQL scripts
- Identify the output of an SQL query
Key vocabulary
- ORDER BY
- Sorts the results of a query.
- ASC
- Ascending order: smallest first, or A to Z.
- DESC
- Descending order: largest first, or Z to A.
- COUNT
- Counts how many records match.
- SUM
- Adds up the values in a number field for the matching records.
Check your learning
- Quick check: 4 questions
- Key vocabulary test: 5 terms
- Activity 1: Write the query · 5 tasks
- Activity 2: What will it output? · 6 questions
- Activity 3: Sorting and totals quiz · 8 questions