Single-Line SQL: Retrieve Employee Names | Dataford Interview Questions

Phenom needs a simple employee directory query for its internal Employee Experience platform. Write a single-line PostgreSQL query that retrieves the name of every employee from the employee table.

Requirements

Return one column containing all employee names.
Sort the names alphabetically so the output is deterministic.
Do not filter employees by department or employment status.

Schema

employee

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
department	VARCHAR(80)	Employee's department, if assigned
employment_status	VARCHAR(30)	Current employment status
work_email	VARCHAR(150)	Employee's work email address

Your question is Single-Line SQL: Retrieve Employee Names. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Phenom needs a simple employee directory query for its internal Employee Experience platform. Write a single-line PostgreSQL query that retrieves the name of every employee from the employee table.

Requirements

Return one column containing all employee names.
Sort the names alphabetically so the output is deterministic.
Do not filter employees by department or employment status.

Schema

employee

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
department	VARCHAR(80)	Employee's department, if assigned
employment_status	VARCHAR(30)	Current employment status
work_email	VARCHAR(150)	Employee's work email address

Your question is Single-Line SQL: Retrieve Employee Names. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.