EasySQL
Filter Employees by Department
SQLDatabases
Write a SQL query that returns all employees in the Engineering department,
ordered by salary descending.
Table: employees
| id | name | salary | department |
|---|---|---|---|
| 1 | Alice | 75000 | Engineering |
| 2 | Bob | 45000 | Marketing |
| 3 | Carol | 82000 | Engineering |
| 4 | Dave | 55000 | Marketing |
| 5 | Eve | 91000 | Engineering |
Expected output (columns: id, name, salary)
5|Eve|91000
3|Carol|82000
1|Alice|75000SQLite 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"