COURSE 8 OF 15
Duplicates, Median and Mode
Find what repeats, keep one of it, and summarise a column by its middle and its most common value.
Builds on
Best read after 2. Grouping and Aggregation, 4. Subqueries, CTEs and Set Operations — you can still read ahead, but some of this may lean on ideas covered there.