WHERE vs HAVING in Operations | Dataford Interview Questions

Your question is WHERE vs HAVING in Operations. Take a moment with it on the right.

Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).

Problem

Context

At companies like FleetOps, operational dashboards often need both row-level filtering and group-level filtering. Interviewers ask this to confirm that you understand when filtering happens in SQL execution.

Core question

Explain the difference between WHERE and HAVING in SQL. In your answer, cover:

What each clause filters
When each clause is evaluated in a query
Why WHERE cannot usually filter aggregate results directly
A simple example showing both clauses used correctly in the same query

Scope guidance

Keep the explanation practical. The interviewer is usually looking for a clear distinction between row-level filtering and post-aggregation filtering, plus one or two examples of common mistakes such as using HAVING when WHERE is more appropriate.

Your question is WHERE vs HAVING in Operations. Take a moment with it on the right.

Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).

Context

Core question

Explain the difference between WHERE and HAVING in SQL. In your answer, cover:

What each clause filters
When each clause is evaluated in a query
Why WHERE cannot usually filter aggregate results directly
A simple example showing both clauses used correctly in the same query