Questions about combinatorial statistics

sjhsjnlg

I want to make a combined statistics, who can tell me how to achieve

For example: a table with gender: male / female, political appearance: / people / members / party members

Now want to count a list, the horizontal axis and vertical axis of the list can be composed of one or more of the above 3 fields.

nuaa31203

Combining query statements is enough.
For example, select the gender/education combination in the front, select count(*) from tab group by gender, education

sjhsjnlg

This result is not comprehensive. .

The desired result should be
such as:
Gender Male: Number of attending (primary school/secondary school/university)
    Female: Number of attending (primary school/secondary school/university)
Need to be listed separately

Please continue to help