Left Join in SQL | Dataford Interview Questions

What is Left join in SQL.

Asked in the Technical Interview II stage. Write a PostgreSQL query that lists every employee and any project assignment associated with that employee.

Output

One row per employee-project match, plus one row for employees without assignments.
Columns: employee_id, employee_name, project_name, and assignment_status.
Preserve employees with no matching assignment using NULL values for assignment columns.
Order by employee_id ascending, then project_name ascending with NULL project names first.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee full name

employee_projects

Column	Type	Description
assignment_idPK	INT	Unique project assignment identifier
employee_id	INT	Employee assigned to the project
project_name	VARCHAR(150)	Assigned project name
assignment_status	VARCHAR(40)	Current assignment status

Your question is Left Join in SQL. 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