Your question is SQL Join for Managers. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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.
Write a PostgreSQL query that returns all columns from employee_info for employees whose matching record in employee_position has position_title = 'Manager'.
emp_id.employee_info, excluding position table columns.Manager.emp_id ascending for deterministic output.| Column | Type | Description |
|---|---|---|
| emp_idPK | INTEGER | Employee identifier |
| full_name | VARCHAR(100) | Employee's full name |
| department | VARCHAR(80) | Fidelity business department |
| VARCHAR(150) | Corporate email address | |
| hire_date | DATE | Employee hire date |
| 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 |