By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 3
| employee_name | role | date_joined |
|---|---|---|
| Jane | 1004 | 2020-08-09 |
| John | 1001 | 2018-01-09 |
| John | 3004 | 2018-01-09 |
| Sam | 1003 | 2022-03-31 |
| Sam | 8000 | 2022-03-31 |
| Sam | 3000 | 2022-03-31 |
SELECT 6