SQL advice_ PLEASE HELP!!!

cs30team2's Avatar, Join Date: Aug 2010
Newbie Member
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.
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
So what help you are looking for? Is the query not running, giving error or something else.
0
cs30team2's Avatar, Join Date: Aug 2010
Newbie Member
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
__________________________________________________ _____________

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.