🏠 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

Designing Efficient SQL Queries

#sql #database #query-optimization

Create optimized SQL queries for data retrieval

I need to design a SQL query for a database with tables: users (id, name, email, created_at), orders (id, user_id, total, status, date), and order_items (id, order_id, product_id, quantity, price). The query should return the top 10 customers by total spending in the last 30 days, including their name, email, total spent, and number of orders. The query should be efficient and handle large datasets.