🏠 Accueil
Benchmarks
📊 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 📖 Glossaire IA 🔗 Liens Utiles
intermediate

High-Value Customer SQL Query

#sql #database #analytics

Generate a SQL query to identify top customers based on spending.

Construct a PostgreSQL query to select the top 10 users with the highest total purchase amount from the 'orders' table. The output should include user_id, user_name, and the sum of their total_orders, sorted by the total amount in descending order.