a) Two columns - the Filipino Population and the Total Population
b) The Filipino Population as a percentage of the total population
SELECT DISTINCTROW POPDATA.CITYNUM,
COUNT (*) FROM POPDATA
GROUP BY POPDATA.CITYNUM
ORDER BY COUNT (*) DESC[/td]
I really have no idea how to do it so if you could please help me, I would appreciate it! Thank you!