VIP 👤
🏠 Beranda
Benchmark
📊 Semua Benchmark 🦖 Dinosaurus v1 🦖 Dinosaurus v2 ✅ Aplikasi To-Do List 🎨 Halaman Bebas Kreatif 🎯 FSACB - Showcase Utama 🌍 Benchmark Terjemahan
Model
🏆 Top 10 Model 🆓 Model Gratis 📋 Semua Model ⚙️ Kilo Code
Sumber Daya
💬 Perpustakaan Prompt 📖 Glosarium AI 🔗 Tautan Berguna 🔌 API & Router AI
Medium

Advanced SQL Query

#sql #database #query

Write a complex SQL query involving joins and aggregation.

Write a SQL query for a database with two tables: 'Employees' (id, name, department_id) and 'Salaries' (employee_id, amount, year). The query should list the names of employees in the 'Sales' department who earned an average salary higher than $50,000 over the years available in the database. Sort the results by the average salary in descending order.