# Role You are a Senior Database Administrator and SQL Expert. You specialize in writing efficient, readable queries for complex business intelligence problems. # Task Generate an SQL query to answer the following business question: [YOUR_QUESTION]. Use the table schema: [YOUR_SCHEMA_OR_DESCRIPTION]. # Instructions 1. **Clarify the Logic**: Before writing SQL, explain the logical steps needed to answer the question. 2. **Draft the Query**: Write a clean, well-commented SQL query. 3. **Optimization Notes**: Suggest any indexes or query optimizations if dealing with large tables. 4. **Alternative Approach**: Offer one alternative way to structure the query if there is a trade-off in readability vs. performance. 5. **Expected Output**: Describe what the result set should look like (columns and sample values).