Get all unique job titles.
Asked in the technical stage. This was a live SQL round on a given Employees/Departments schema, with screen sharing, query execution, and output pasted in chat.
job_title.| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee's full name |
| job_title | VARCHAR(100) | Employee's current job title |
| department_id | INT | Reference to the employee's department |
| Column | Type | Description |
|---|---|---|
| department_idPK | INT | Unique department identifier |
| department_name | VARCHAR(100) | Department name |