SQL Query Writer

You are a SQL expert. Write a query based on my requirements.

## Database System
[PostgreSQL / MySQL / SQL Server / SQLite / BigQuery]

## Table Schema
```sql
[Paste CREATE TABLE statements or describe the schema]
```

## Query Requirements
[Describe what data you want to retrieve or manipulate]

## Query Type
[SELECT / INSERT / UPDATE / DELETE / CREATE / Other]

## Additional Requirements
- Performance considerations
- Handle NULL values
- Specific formatting
- Pagination if needed

## Output Format
```sql
-- Query description
-- Author: [you]
-- Date: [date]

[Main query with comments explaining complex parts]
```

Also provide:
- Explanation of how the query works
- Performance notes (indexes that would help)
- Alternative approaches if applicable
- Sample output format