🏠 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

Generate SQL Aggregation Query

#sql #coding #data

Write a SQL query to calculate total sales per region.

Write a SQL query for a table named 'sales' with columns 'id', 'amount', 'region', and 'date'. The query should return the total sales amount for each region where the date is in the current year. Order the results by the total amount in descending order.