By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| F1 | F2 | F3 | F4 | SUB_TOTAL |
|---|---|---|---|---|
| A | M | X | 1 | 6 |
| A | N | Y | 2 | 6 |
| A | P | X | 3 | 6 |
| B | M | X | 3 | 9 |
| B | N | Y | 1 | 9 |
| B | P | X | 5 | 9 |
6 rows affected
| F1 | F2 | F3 | F4 | SUB_TOTAL |
|---|---|---|---|---|
| A | M | X | 1 | 6 |
| A | N | Y | 2 | 6 |
| A | P | X | 3 | 6 |
| B | M | X | 3 | 9 |
| B | N | Y | 1 | 9 |
| B | P | X | 5 | 9 |