Employee Query With Unmatched IDs | Dataford Interview Questions

Cimpress Technology needs an employee-project view for internal staffing. Write a PostgreSQL query that returns every employee from empdetails, including employees who have no matching project in projdetails.

Requirements

Use a LEFT JOIN from empdetails to projdetails using employee_id.
Return the employee name, employee first name, project ID, project name, and project first name.
Preserve employees without projects by returning NULL for project columns.
Order by firstname from empdetails, then firstname from projdetails, placing NULL values last in both sort levels.

Schema

empdetails

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
empname	VARCHAR(100)	Employee's full name
firstname	VARCHAR(50)	Employee's first name

projdetails

Column	Type	Description
project_idPK	INTEGER	Unique project identifier
employee_id	INTEGER	Assigned employee identifier
project_name	VARCHAR(150)	Name of the project
firstname	VARCHAR(50)	Project contact or team first name

Your question is Employee Query With Unmatched IDs. Start with the requirements and the two tables 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