I have 'member' table with a 'nationality' column. I want to get the
percentage breakdown of members by nationality, e.g.
American 29%
Canadian 14%
Mexican 11%
...
Is there an efficient way to do this is a single query?
If I were to do:
SELECT nationality, ((COUNT(*) * 100)/(select count(*) from member)) as
percentage FROM member GROUP BY nationality ORDER BY nationality;
would this repeatedly execute the inner query over and over?
Thanks!
David