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,
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
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.