🏠 Home
Benchmark Hub
📊 All Benchmarks 🦖 Dinosaur v1 🦖 Dinosaur v2 ✅ To-Do List Applications 🎨 Creative Free Pages 🎯 FSACB - Ultimate Showcase 🌍 Translation Benchmark
Models
🏆 Top 10 Models 🆓 Free Models 📋 All Models ⚙️ Kilo Code
Resources
💬 Prompts Library 📖 AI Glossary 🔗 Useful Links
medium

Monthly Sales Report Query

#sql #database #reporting

Generate a SQL query for aggregating sales data.

Write a SQL query for a table named 'orders' with columns 'order_id', 'customer_id', 'amount', and 'order_date'. The query should return the total sales amount and the number of orders for each month in the year 2023, ordered by month.