🏠 Startseite
Vergleiche
📊 Alle Benchmarks 🦖 Dinosaurier v1 🦖 Dinosaurier v2 ✅ To-Do-Listen-Apps 🎨 Kreative freie Seiten 🎯 FSACB - Ultimatives Showcase 🌍 Übersetzungs-Benchmark
Modelle
🏆 Top 10 Modelle 🆓 Kostenlose Modelle 📋 Alle Modelle ⚙️ Kilo Code
Ressourcen
💬 Prompt-Bibliothek 📖 KI-Glossar 🔗 Nützliche 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.