Medium
SQL Query Generator
Generates complex SQL queries based on natural language descriptions of requirements.
📝 提示内容
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]: