By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 7
| group_id | item_name |
|---|---|
| 1 | car |
| 1 | van |
| 1 | motorbike |
| 3 | helicopter |
| 3 | plane |
| 6 | boat |
| 6 | submarine |
SELECT 7
| group_id | item_name | group_running_no |
|---|---|---|
| 1 | car | 1 |
| 1 | van | 1 |
| 1 | motorbike | 1 |
| 3 | helicopter | 2 |
| 3 | plane | 2 |
| 6 | boat | 3 |
| 6 | submarine | 3 |
SELECT 7