SQL for Data Analysis

3 modules · 7 objectives · built from 6 sources, grouped by topic

Start practising →
3 objectives · 91%
3 objectives · 84%
Choose the right join for a reporting questionRenameMergeSplitRemove
Count rows correctly when NULLs are presentRenameMergeSplitRemove
Your sources disagree here“NULLs are excluded from COUNT(column)” — Relational databases · p. 22“COUNT always includes NULLs” — GROUP BY in 10 minutes · 4:10Both are shown; neither is hidden. Checks will avoid this point until you choose.
◌ Not covered yet

Not covered yet. Only one of your sources mentions window functions, in a single sentence — not enough to build checks. No checks will be created until coverage improves.

Add a source

Tip: use ↑ ↓ to reorder with the keyboard. Edits keep their evidence attached.