🏠 Home
Prestatietests
📊 Alle benchmarks 🦖 Dinosaur v1 🦖 Dinosaur v2 ✅ To-Do List applicaties 🎨 Creatieve vrije pagina's 🎯 FSACB - Ultieme showcase 🌍 Vertaalbenchmark
Modellen
🏆 Top 10 modellen 🆓 Gratis modellen 📋 Alle modellen ⚙️ Kilo Code
Bronnen
💬 Promptbibliotheek 📖 AI-woordenlijst 🔗 Nuttige links
Intermediate

SQL Query Constructor

#database #coding #data

Generate SQL queries based on natural language requirements.

Write a SQL query for a PostgreSQL database. The database has two tables: 'employees' (id, name, department_id, salary) and 'departments' (id, name). The query should return the names of all departments and the average salary of employees in those departments, but only include departments where the average salary is greater than 50,000. Order the results by average salary in descending order.