By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
14 rows affected
| item | statusid | occurence |
|---|---|---|
| pencil | A | 3 |
| pencil | B | 2 |
| pencil | C | 1 |
| eraser | D | 2 |
| eraser | E | 2 |
| eraser | F | 2 |
14 rows affected
| item | statusid | occurence |
|---|---|---|
| pencil | A | 3 |
| pencil | B | 2 |
| pencil | C | 1 |
| eraser | D | 2 |
| eraser | E | 2 |
| eraser | F | 2 |