🏠 Home
Prestatietests
📊 Alle benchmarks 🦖 Dinosaur v1 🦖 Dinosaur v2 ✅ To-Do List applicaties 🎨 Creatieve vrije pagina's 🎯 FSACB - Ultieme showcase 🌍 Vertaalbenchmark
Modellen
🏆 Top 10 modellen 🆓 Gratis modellen 📋 Alle modellen ⚙️ Kilo Code
Bronnen
💬 Promptbibliotheek 📖 AI-woordenlijst 🔗 Nuttige links
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.