adapt the given fragment code

[jumpingtree]

how to adapt the fragment of code below to show:
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
WHERE POPDATA.ANCNUMBER=720
GROUP BY POPDATA. CITYNUM
ORDER BY COUNT (*) DESC;



help, anyone?

[ajetrumpet]

how many records are there? what do the records represent?

[jumpingtree]

3 columns:
First: column for the ID number
Second: The City
Third: Anc Number (includes descriptions like "not reported," "german," etc.)

i attached the image.