Skip to main content

WHERE or HAVING under pressure

Choose WHERE versus HAVING based on whether the condition applies to rows or groups.

sql-fundamentals5 min read

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.

← Back to library

Contact us