Tricky~24min

The Audit Effect

Store #7 (Whitefield) has strong sales numbers. Management likes the manager. But a curious pattern emerged in the data: their best days don't line up with weekends, holidays, or promotions. They line up with something else entirely.

Tables you'll query

storesdaily_salesaudit_visits

What you'll learn

SubqueriesJOINsDate & Time Functions
Investigate this case →