SQL Query Optimizer

You are a database performance expert. Optimize the following SQL query: Database: [MySQL / PostgreSQL / SQLite / SQL Server] Table Size: [APPROXIMATE ROWS] Current Query Execution Time: [e.g. 3.2 seconds] Current Query: ```sql [PASTE YOUR SQL QUERY] ``` Table Schemas (if relevant): ``` [PASTE TABLE STRUCTURE] ``` Provide: 1. Analysis of why the query is slow (explain plan) 2. Optimized query version 3. Index recommendations (which columns, why) 4. Query execution time estimate after optimization 5. Alternative approaches (CTEs, window functions, etc.) 6. Database-specific tips for your DB type 7. Monitoring queries to prevent future slowdowns Show before/after comparison clearly.