Data Analyst · SQL · Junior · Theory

What's the difference between WHERE and HAVING in SQL?

~4 min by voice

How to approach it

This checks whether the candidate understands the logical order of SQL query execution: where individual rows are filtered and where groups are filtered after aggregation, and whether they can apply that in practice.

Have you seen this question in a real interview?

Answers0

Avg. score—

Strong—

Practiced0

Topics

sql aggregation

Similar questions

You have a query with window functions over a billion-row events table, and it takes forty minutes. How would you investigate, and what would you optimize? Senior Write a function that takes a list of access log lines, each containing, separated by spaces, the method, path, response code, and response time in milliseconds, and returns, for each path, the number of requests and the average response time. Lines that can't be parsed should be skipped. Junior A query that used to run in milliseconds now takes seconds after the table grew to tens of millions of rows. How would you investigate, and what can you do about it? Mid-level What are a primary key and a foreign key? And how would you model a many-to-many relationship, for example students and courses? Junior In which cases would you deliberately denormalize a database schema, and what's the price you pay for it? Mid-level

Answer by voice

The interviewer will ask this question and listen. Think out loud and ask for a hint if you need one. When you're done, pause or tap “That's my answer”. In about a minute, your score and the points you covered show up here.

Best with headphones · ~4 min