Partial Solution to "Most Filipino" Cities Problem Below is a partial solution to the challenge to write an SQL query to find to list the US cities that have the highest percentage of Filipinos. SELECT DISTINCTROW POPDATA.CITYNUM, COUNT(*)FROM POPDATA WHERE POPDATA.ANCNUMBER=720 GROUP BY POPDATA.CITYNUM ORDER BY COUNT(*) DESC; In your teams, do this. Register for a free forum that gives programming advice and try to ask 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 __________________________________________________ Good Day! Given that we are not programming majors, we would like to request assistance on how to get the complete solution for this task. We would very much appreciate anyone who could help us fulfill this task. THANK YOU!
