🏠 Accueil
基準測試
📊 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 📖 人工智能詞彙表 🔗 Liens Utiles
medium

Generate Complex SQL Query

#sql #database #query-writing

Write a SQL query to join multiple tables and aggregate data.

Write a PostgreSQL query that lists the top 5 customers by total purchase amount in the last month. Assume tables named 'customers' (id, name) and 'orders' (id, customer_id, amount, date). Join the tables, filter for the last month, group by customer, and order by the total sum descending.