I want to count male, female and total students from Student table for a specific year specified. I wish if the result could be displayed in the form:
====================================
| Label | Value | Year |
====================================
| Male | 0 | 2013 |
| Female | 23 | 2013 |
| Total | 23 | 2013 |
====================================
The query should display 0 if there is no male/female matching for the specified year. Any idea how I can make this happen?
Thanks in advance
See Question&Answers more detail:os