🏠 Inicio
Pruebas de rendimiento
📊 Todos los benchmarks 🦖 Dinosaurio v1 🦖 Dinosaurio v2 ✅ Aplicaciones To-Do List 🎨 Páginas libres creativas 🎯 FSACB - Showcase definitivo 🌍 Benchmark de traducción
Modelos
🏆 Top 10 modelos 🆓 Modelos gratuitos 📋 Todos los modelos ⚙️ Kilo Code
Recursos
💬 Biblioteca de prompts 📖 Glosario de IA 🔗 Enlaces útiles
Intermediate

Write SQL Sales Aggregation

#sql #database #data-analysis

Construct a SQL query to calculate total sales per region.

Write a SQL query for a table named 'sales' which has columns 'id', 'product_name', 'region', 'amount', and 'sale_date'. The query should calculate the total sales amount for each region. Only include sales that occurred in the current year. Order the results by the total sales amount in descending order.