🏠 Hem
Benchmarkar
📊 Alla benchmarkar 🦖 Dinosaur v1 🦖 Dinosaur v2 ✅ To-Do List-applikationer 🎨 Kreativa fria sidor 🎯 FSACB - Ultimata uppvisningen 🌍 Översättningsbenchmark
Modeller
🏆 Topp 10 modeller 🆓 Gratis modeller 📋 Alla modeller ⚙️ Kilo Code
Resurser
💬 Promptbibliotek 📖 AI-ordlista 🔗 Användbara länkar
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.