TM254 – Block 2 Part 8: Further data manipulation using SQL (Offline Quiz)

Aggregation • GROUP BY/HAVING • JOINs • ORDER BY/LIMIT/OFFSET • VIEWs • COALESCE • gotchas. :contentReference[oaicite:1]{index=1}

Settings

Mode

Number of questions

Question bank: 0

Options

Shuffle Explanations

If it opens blank: check it isn’t saved as 8.html.txt.

Ready

What this covers

Aggregate functions (SUM, MAX, MIN, AVG, COUNT) + DISTINCT + NULL behaviour.
GROUP BY and HAVING + full logical processing model.
JOIN types: CROSS, INNER (ON), NATURAL, LEFT/RIGHT/FULL OUTER.
ORDER BY (ASC/DESC/NULLS FIRST/LAST), LIMIT and OFFSET (paging gotchas).
VIEWs (CREATE VIEW, use like a table, DROP VIEW) + derived vs base tables.
COALESCE for replacing NULL in outputs.