codejump
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, name
employees: id, name, dept_id

deptname
1Engineering
2Marketing
3Sales
empnamedept_id
1Alice1
2Bob2
3Carol1
4Dave3

Expected output (columns: employee_name, department_name)

Alice|Engineering
Bob|Marketing
Carol|Engineering
Dave|Sales

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 #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"
← All challenges