Your question is On-the-Spot SQL Query Writing. 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).
Describe how you approach an on-the-spot SQL question that requires writing a query.
The interviewer is testing how you clarify the metric, identify the right grain, and avoid common SQL mistakes under time pressure. Focus on how you reason through the problem before typing, then how you validate the result with a quick sanity check.