Routine~14min
The Wrong Quarter
The dashboard says Q2 was the best quarter and Q4 was the worst. But when you calculate revenue from actual order dates, you get the opposite result. The quarter labels are wrong.
Tables you'll query
sales_repssalesquarterly_targets
What you'll learn
Aggregations & GROUP BYDate & Time Functions