🏠 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
hard

Complex SQL JOIN Query

#sql #database #query

Write a SQL query to aggregate sales data from multiple tables.

Write a SQL query that selects the top 5 customers by total purchase amount in the last year. Assume three tables: 'customers', 'orders', and 'order_items'. You will need to join these tables and use a GROUP BY clause with a SUM aggregation.