Using QUALIFY, return city, first_name and hire_date of the earliest hire in each city (one person per city; ties by emp_id).
7 rows with columns city, first_name, hire_date — first 3 shown:
| # | |||
|---|---|---|---|
| 1 | Hyderabad | Ishita | 2019-09-23 |
| 2 | Pune | Neha | 2016-02-01 |
| 3 | Mumbai | Vikram | 2016-09-01 |
Run your code to see the output here.