By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| NAME | YEARS_AT_COMPANY | ROLE | BEACH |
|---|---|---|---|
| Bob | 1 | Sales | 1 |
| Bob | 2 | Sales | 0 |
| Bob | 3 | Sales | 0 |
| Bob | 4 | IT | 1 |
| Bob | 5 | Sales | 1 |
| Bob | 6 | Marketing | 1 |
| NAME | YEARS_AT_COMPANY | ROLE | BEACH |
|---|---|---|---|
| Bob | 1 | Sales | 1 |
| Bob | 2 | Sales | 0 |
| Bob | 3 | Sales | 0 |
| Bob | 4 | IT | 1 |
| Bob | 5 | Sales | 1 |
| Bob | 6 | Marketing | 1 |