codejump
EasySQL

Filter Employees by Department

SQLDatabases

Write a SQL query that returns all employees in the Engineering department,
ordered by salary descending.

Table: `employees`

idnamesalarydepartment
1Alice75000Engineering
2Bob45000Marketing
3Carol82000Engineering
4Dave55000Marketing
5Eve91000Engineering

Expected output (columns: id, name, salary)

5|Eve|91000
3|Carol|82000
1|Alice|75000

SQLite output format — rows are pipe-separated (|) with no column headers.

Example: SELECT id, name FROM users WHERE id = 1 → 1|Alice

Sample tests

Test #1Returns 3 Engineering employees sorted by salary DESC
Input: "CREATE TABLE employees (id INTEGER, name TEXT, salary INTEGER, department TEXT);\nINSERT INTO employees VALUES\n (1, 'Alice', 75000, 'Engineering'),\n (2, 'Bob', 45000, 'Marketing'),\n (3, 'Carol', 82000, 'Engineering'),\n (4, 'Dave', 55000, 'Marketing'),\n (5, 'Eve', 91000, 'Engineering');"
Output: "5|Eve|91000\n3|Carol|82000\n1|Alice|75000"
← All challenges