PowerBlue

Hello! :) 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 WHERE POPDATA.ANCNUMBER=720 GROUP BY POPDATA.CITYNUM ORDER BY COUNT(*) DESC; Thank you very much. Hoping for your kind reply. :)