🏠 Startseite
Vergleiche
📊 Alle Benchmarks 🦖 Dinosaurier v1 🦖 Dinosaurier v2 ✅ To-Do-Listen-Apps 🎨 Kreative freie Seiten 🎯 FSACB - Ultimatives Showcase 🌍 Übersetzungs-Benchmark
Modelle
🏆 Top 10 Modelle 🆓 Kostenlose Modelle 📋 Alle Modelle ⚙️ Kilo Code
Ressourcen
💬 Prompt-Bibliothek 📖 KI-Glossar 🔗 Nützliche Links
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.