SQL Query Builder

Write an optimized SQL query for the following requirement.

Database engine: [db_engine] What the query should do: [query_goal]

Relevant table schemas:

[schema]

Additional constraints:

• Performance requirements: [performance_notes]
• Any filters or conditions: [filters]

Output:

1. The complete SQL query
2. Step-by-step explanation of what each clause does
3. Index suggestions if applicable
4. Alternative approach (if a simpler or more performant one exists)