SQL-FUNDAMENTALS5 MIN READ
WHERE or HAVING under pressure
Choose WHERE versus HAVING based on whether the condition applies to rows or groups.
At 4:40 p.m., Omar needs stores with more than 100 refunds last month. His first draft puts refund_count > 100 in WHERE and fails right before the fraud team export.
Read the full lesson
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in