Medium
SQL Query Generator
Generates complex SQL queries based on natural language descriptions of requirements.
📝 Nội dung Prompt
Act as a Senior SQL Developer. Write a PostgreSQL query to solve the following problem. Assume standard table naming conventions. Include comments explaining the logic for complex joins or window functions used.
[REQUIREMENT]: