Your question is Employee and Manager Join Query. Start with the requirements and the one table 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.
Beaconfiresolution needs an employee directory showing each employee and the person they report to. The reporting hierarchy is stored in a single employee table.
Write a PostgreSQL query to return every employee's name and manager's name.
employee table to match each employee with their manager.No manager when an employee's manager_id is NULL.| Column | Type | Description |
|---|---|---|
| employee_idPK | INTEGER | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee's full name |
| manager_id | INTEGER | References employee_id for the employee's manager |