🏠 Accueil
Benchmarks
📊 Tous les Benchmarks 🦖 Dinosaure v1 🦖 Dinosaure v2 ✅ To-Do List Apps 🎨 Pages Libres 🎯 FSACB - Showcase 🌍 Traduction
Modèles
🏆 Top 10 Modèles 🆓 Modèles Gratuits 📋 Tous les Modèles ⚙️ Modes Kilo Code
Ressources
💬 Prompts IA 📖 Glossaire IA 🔗 Liens Utiles
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.