i have a problem with mysql select group..
my table is tbluser.. i want to count how much male and female with plan A or plan B.. my table data like this
| plan | sex |
|---|---|
| plan A | male |
| plan B | female |
example result
| plan | male | female | total |
|---|---|---|---|
| plan A | 3 | 6 | 9 |
| plan B | 2 | 4 | 8 |
im hope some one can help me.....
im hope someone can help me coz i cannot solve this problem since 1week
