[FONT="]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. [/FONT]
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. [FONT="]SELECT DISTINCTROW POPDATA.CITYNUM, COUNT(*)FROM POPDATA WHERE POPDATA.ANCNUMBER=720 GROUP BY POPDATA.CITYNUM ORDER BY COUNT(*) DESC; [/FONT]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 _______________________________________________________________ This was the assigned task. So we are searching for answers on how we can find a complete solution in a more understandable languange, since we're not programming majors. Thank you.
