SQL: aggregates, groups, joins and changes
Part 2 — summarising data, combining two tables, and changing rows.
In this lesson you will
- Use COUNT, SUM, AVG, MIN and MAX, and explain how they treat NULL
- Group rows with GROUP BY and filter groups with HAVING
- Join two tables by Cartesian product, equi-join and natural join
- Change and remove rows with UPDATE and DELETE