SQL filtering and aggregation
Use sql filtering and aggregation to make decisions inspectable.
What you should be able to do
Independently: Practise SELECT, WHERE and GROUP BY and check results by hand.
Suggested prerequisites
A short guide
Use sql filtering and aggregation to make decisions inspectable. Practise SELECT, WHERE and GROUP BY and check results by hand. Read the indicated source section, identify its key concepts and conditions, and work through the example. Record inputs, sources, units and assumptions. Keep your method separate from the result, mark unanswered questions, and review the output against the checklist.
An example
COUNT(*) counts rows, not necessarily unique users.
Your task
Practise SELECT, WHERE and GROUP BY and check results by hand.
Start with this source
Read the indicated section relevant to sql filtering and aggregation and complete the foundation task.
This source is awaiting renewed review. Try the task above and adjacent skills; reviewed sources will appear here.
Your learning checklist
Required items: 0 / 10 completed or already known
Next: Read a role through its responsibilities
Checklist statuses are self-reported; exercise scores are recorded separately. You can reset any item.