By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 3
| gender | count_gender | gen_male | gen_female |
|---|---|---|---|
| Group 21 - 40 | 2 | 1 | 1 |
| Group <= 20 | 1 | 1 | 0 |
SELECT 2
CREATE TABLE
INSERT 0 3
| gender | count_gender | gen_male | gen_female |
|---|---|---|---|
| Group 21 - 40 | 2 | 1 | 1 |
| Group <= 20 | 1 | 1 | 0 |
SELECT 2