SQL Generation

Casos de uso

• Converting business questions to SQL queries
• Optimizing slow queries with EXPLAIN analysis
• Generating migration scripts
• Building complex reporting queries
• Database schema design from requirements

Generate a PostgreSQL query for the following requirement:

"Find the top 10 customers by total order value in the last 30 days,
including their order count and average order value. Exclude customers
who have any cancelled orders."

Schema context:
- customers (id, name, email, created_at)
- orders (id, customer_id, total, status, created_at)

Requirements:
- Use CTEs for readability
- Include performance hints (indexes to consider)
- Explain the query logic step by step

Modelos recomendados

Herramientas compatibles

Modalidades

Skills relacionadas