SQL Join for Managers | Dataford Interview Questions

Context

Fidelity Investments maintains employee details separately from current position assignments. HR reporting needs the complete employee records for people currently assigned to the Manager position.

Task

Write a PostgreSQL query that returns all columns from employee_info for employees whose matching record in employee_position has position_title = 'Manager'.

Requirements

Join the tables using emp_id.
Return every column from employee_info, excluding position table columns.
Include only employees whose position is exactly Manager.
Order the results by emp_id ascending for deterministic output.

Schema

employee_info

Column	Type	Description
emp_idPK	INTEGER	Employee identifier
full_name	VARCHAR(100)	Employee's full name
department	VARCHAR(80)	Fidelity business department
email	VARCHAR(150)	Corporate email address
hire_date	DATE	Employee hire date

employee_position

Column	Type	Description
emp_idPK	INTEGER	Employee identifier from the position feed
position_title	VARCHAR(80)	Current position assignment
effective_date	DATE	Date the position became effective

Your question is SQL Join for Managers. 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