Members gender count and percentage

[brown2005]

SELECT genders_name, COUNT(genders_name) AS genders_count FROM people, members, genders WHERE members_person=people_id AND people_gender=genders_id GROUP BY genders_name ORDER BY genders_name ASC

 

I have the above code, which would say echo in php

 

Gender      Number            Percentage

Male          2

Female      1

 

I would like to add the percentage fields for this, can this be done in the above mysql code or does it need to be a separate code?

 

Thanks

[jim_keller]

I would probably just do this in code. To do it in mySQL, you'd have to use subselects. This stack overflow post has some information on getting percentages in your query using subselects though: http://stackoverflow.com/questions/1372260/get-percentage-average

 

 

[fenway]

And there's nothing wrong with a subselect to get the total count for everything - super easy.