Distinct counts
COUNT DISTINCT avoids counting an entity repeatedly when it appears in multiple records.
3 minutes. No sign-up needed.
This lesson is part of the Data Analytics course.
Example plan3 lessons · 11 min
WHERE and HAVING4 min
Distinct countsSQL aggregation3 min
Rates in SQLSQL aggregation4 min
An example. Your plan follows your answers, so it can start later and end sooner.
Build my plan
Start free, no account needed.