QCE Digital Solutions Unit 2: SQL SELECT queries, grouping and aggregates
Students write SQL SELECT queries that filter, sort, count, group and summarise data using WHERE, IN, ORDER BY, aggregate functions, GROUP BY and HAVING.
One content description from the full QCE Digital Solutions Unit 2 — Prototype Data Solutions journey. All 12 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (12)
1
What SQL is
2
Running an SQL query in a database tool
3
SQL SELECT and FROM
4
SQL WHERE conditions
5
Boolean operators AND, OR and NOT in a WHERE clause
6
BETWEEN and IN in a WHERE clause
7
SQL ORDER BY
8
SQL aggregate functions: COUNT, SUM, AVG, MIN, MAX
9
SQL COUNT function
10
SQL GROUP BY
11
SQL HAVING
12
Clause order in a full SQL query
For Teachers
Add this journey to your class and track every student in real time.
Create a free teacher account →No credit card. No setup fee. Make a class and invite students in under three minutes.
For Students
Start this journey on Cloodit — track progress, earn badges, and play live sprints with your class.
Start Learning Free →