[inder]

Try the following:
SELECT country, count(1)/(SELECT COUNT(*) FROM countries)*100.0 AS pct
FROM countries GROUP BY country -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[inder]

Try the following:
SELECT country, count(1)/(SELECT COUNT(*) FROM countries)*100.0 AS pct
FROM countries GROUP BY country -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --