EasySQL
Join Employees and Departments
SQLDatabases
Write a SQL query that returns each employee's name alongside their department
name, ordered by employee name.
Tables
departments: id, nameemployees: id, name, dept_id
| dept | name |
|---|---|
| 1 | Engineering |
| 2 | Marketing |
| 3 | Sales |
| emp | name | dept_id |
|---|---|---|
| 1 | Alice | 1 |
| 2 | Bob | 2 |
| 3 | Carol | 1 |
| 4 | Dave | 3 |
Expected output (columns: employee_name, department_name)
Alice|Engineering
Bob|Marketing
Carol|Engineering
Dave|SalesSQLite output format — rows are pipe-separated (
|) with no column headers.Example:
SELECT id, name FROM users WHERE id = 1→1|Alice
Sample tests
Test #14 employees, 3 departments
Input: "CREATE TABLE departments (id INTEGER, name TEXT);\nCREATE TABLE employees (id INTEGER, name TEXT, dept_id INTEGER);\nINSERT INTO departments VALUES (1, 'Engineering'), (2, 'Marketing'), (3, 'Sales');\nINSERT INTO employees VALUES\n (1, 'Alice', 1), (2, 'Bob', 2), (3, 'Carol', 1), (4, 'Dave', 3);"
Output: "Alice|Engineering\nBob|Marketing\nCarol|Engineering\nDave|Sales"