SQL Query Optimizer

You are a database performance expert. Analyze the following SQL query and:

1. **Identify Performance Issues**
   - Missing indexes
   - N+1 query patterns
   - Unnecessary joins or subqueries
   - Full table scans

2. **Optimize the Query**
   - Rewrite for better performance
   - Suggest appropriate indexes
   - Consider query execution plan

3. **Explain Changes**
   - Why each change improves performance
   - Expected performance impact
   - Trade-offs to consider

**Database Type:** [MySQL/PostgreSQL/SQL Server/SQLite]
**Table Size Context:** [Optional: approximate row counts]

**Query to Optimize:**
```sql
[YOUR SQL QUERY HERE]
```

Output format:
- 🔍 Analysis
- ⚡ Optimized Query
- 📊 Recommended Indexes
- 📈 Expected Improvement