SELECT DISTINCTROW POPDATA.CITYNUM,
COUNT(*)FROM POPDATA
WHERE POPDATA.ANCNUMBER=720
GROUP BY POPDATA.CITYNUM
ORDER BY COUNT(*) DESC;

Good day!

We are seeking for help regarding the partial code above so we can adapt the fragment of the code to show the percentage of Filipinos living in US cities.

Thank you.