By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
9 rows affected
| man_id | subgroup | power | grp |
|---|---|---|---|
| 1 | Sub_A | 4 | Group_A |
| 2 | Sub_B | -1 | Group_A |
| 3 | Sub_A | -1 | Group_B |
| 4 | Sub_B | 6 | Group_B |
| 5 | Sub_A | 5 | Group_A |
| 6 | Sub_B | 1 | Group_A |
| 7 | Sub_A | -1 | Group_B |
| 8 | Sub_B | 2 | Group_B |