By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 2 Duplicates: 0 Warnings: 0
| occupation | Name |
|---|---|
| Writer | John |
| Driver | Sam |
| line | occupation | linetype |
|---|---|---|
| John(W) | Writer | 1 |
| Sam(D) | Driver | 1 |
| There are a total of 1 Writers | Writer | 2 |
| There are a total of 1 Drivers | Driver | 2 |