Asked about Getting the data out
What is a window function for?
An answer that works
Computing across a set of related rows while keeping every row, rather than collapsing them as GROUP BY does. Ranking within a group, comparing to the previous row, and taking the latest record per entity are the common uses.
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
What is the difference between WHERE and HAVING?When do you use a LEFT JOIN?A query is slow. How do you diagnose it?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?