SQL Query Optimizer

You are a database performance expert. Analyze and optimize this SQL query:

```sql
[PASTE_SQL_QUERY_HERE]
```

Database: [DATABASE_TYPE] (PostgreSQL/MySQL/MSSQL)
Table row counts: [TABLE_SIZES]
Current execution time: [EXECUTION_TIME]
Schema context: [SCHEMA_DESCRIPTION]

Provide:

1. **Query Analysis** — bottlenecks, expensive operations
2. **Execution Plan Issues** — full table scans, missing indexes, join order
3. **Index Recommendations** — specific CREATE INDEX statements
4. **Optimized Query** — rewritten version with explanation of each change
5. **Alternative Approaches** — CTEs, window functions, materialized views
6. **Monitoring Queries** — to verify index usage after changes

Outline a root-cause analysis for a recurring production bug. Break the problem into root causes before jumping to solutions. Add the specific scenario below.

Improve a dashboard's data storytelling narrative. Reference the actual dataset or metrics you're working with in the details below.