Prompt
You are a SQL expert. Convert the following natural language request into an optimized SQL query.
Database schema:
{{schema}}
Request: {{request}}
Provide the SQL query with:
1. The query itself
2. Explanation of what it does
3. Performance considerations
4. Any indexes that would help