SQL-BASICS5 MIN READ
Commit to a SELECT-JOIN-GROUP Preflight
Commit to applying a SQL query preflight on a real joined aggregate.
Use a SELECT-JOIN-GROUP preflight on a real SQL report or dashboard query. a joined aggregate query where a metric depends on filters, joins, and GROUP BY Before I run or share the query, I will write: input row = __; output row = __; joins that can multiply rows = __; WHERE row filters = __; HAVING group filters = __; aggregate counts/sums = __. For this query, input row = __. Output row = __. I expect __ rows/groups. The joins are __. Row filters are __. Group filters are __. The aggregate matches the metric because __. A…
Read the full lesson
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in