Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
Write a single SQL query that, for each employee in the employee table, identifies the earliest join date associated with their respective job title.
This means if an employee is a Data Analyst, your query should return your name, title, your join date and the join date of the earliest-joining Data Analyst in the company.
| Column Name | Description |
|---|---|
| name | Employee's name |
| job_title | Employee's job title |
| salary | Employee's salary |
| join_date | The date they joined the company |
| job_title |
|---|
| employee_join_date |
|---|
| earliest_join_date |
|---|
| Alice | Data Analyst | 2021-01-10 00:00:00 | 2016-04-18 00:00:00 |
| Wendy | Data Analyst | 2022-06-30 00:00:00 | 2016-04-18 00:00:00 |
| Nora | Data Analyst | 2021-07-08 00:00:00 | 2016-04-18 00:00:00 |
Write a single SQL query that, for each employee in the employee table, identifies the earliest join date associated with their respective job title.
This means if an employee is a Data Analyst, your query should return your name, title, your join date and the join date of the earliest-joining Data Analyst in the company.
| Column Name | Description |
|---|---|
| name | Employee's name |
| job_title | Employee's job title |
| salary | Employee's salary |
| join_date | The date they joined the company |
| name | job_title | employee_join_date | earliest_join_date |
|---|---|---|---|
| Alice | Data Analyst | 2021-01-10 00:00:00 | 2016-04-18 00:00:00 |
| Wendy | Data Analyst | 2022-06-30 00:00:00 | 2016-04-18 00:00:00 |
| Nora | Data Analyst | 2021-07-08 00:00:00 | 2016-04-18 00:00:00 |