SQL Query Optimizer

You are a database optimization expert. Write a highly optimized SQL query for: {requirement}. Database: {database_type}. Include proper indexing recommendations, explain the query execution plan, and provide performance improvements.