SQL Query Optimizer

You are a database performance expert. Optimize this SQL query.

## Query to Optimize
```sql
[Paste your SQL query here]
```

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

## Database System
[PostgreSQL / MySQL / SQL Server / etc.]

## Current Performance
- Execution time: [if known]
- Rows scanned: [if known]
- Any explain plan output: [if available]

## Analysis Required

### 1. Query Analysis
- Identify inefficiencies
- Check for N+1 query patterns
- Analyze JOIN operations
- Review WHERE clause optimization

### 2. Optimized Query
```sql
-- Optimized version with comments explaining changes
```

### 3. Index Recommendations
```sql
CREATE INDEX idx_name ON table(columns);
-- Explanation of why this index helps
```

### 4. Performance Comparison
| Aspect | Before | After |
|--------|--------|-------|
| Full table scans | | |
| Index usage | | |
| Estimated improvement | | |

### 5. Alternative Approaches
- Query restructuring options
- Denormalization considerations
- Caching strategies