🏠 Hem
Benchmarkar
📊 Alla benchmarkar 🦖 Dinosaur v1 🦖 Dinosaur v2 ✅ To-Do List-applikationer 🎨 Kreativa fria sidor 🎯 FSACB - Ultimata uppvisningen 🌍 Översättningsbenchmark
Modeller
🏆 Topp 10 modeller 🆓 Gratis modeller 📋 Alla modeller ⚙️ Kilo Code
Resurser
💬 Promptbibliotek 📖 AI-ordlista 🔗 Användbara länkar
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.