Can someone help me since I'm having problems with SQL?
I have already fixed the columns as desired and originally planned.
However, I can't seem to show the population as a percentage of the total population.
Does anyone know how can I adapt this code below?
SELECT DISTINCTROW POPDATA.CITYNUM,
COUNT (*) FROM POPDATA
GROUP BY POPDATA.CITYNUM
ORDER BY COUNT(*) DESC;
Thank you very much.