Asked about Getting the data out
What is the difference between WHERE and HAVING?
An answer that works
WHERE filters rows before grouping. HAVING filters groups after aggregation. You cannot reference an aggregate in WHERE because it has not been computed yet.
Reading an answer is not being able to give one. The section that teaches this is Getting the data out, 6 hours of SQL & data access.
Learn this properlyAlso asked about SQL & data access
When do you use a LEFT JOIN?A query is slow. How do you diagnose it?What is a window function for?Write a query for each user's most recent order.Why can NOT IN return nothing?What is the difference between COUNT(*) and COUNT(column)?A client retries a request after a timeout. How do you make sure it is not processed twice?What is a race condition in a read-modify-write, and how do you prevent it?