Go4Expert

Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   SQL advice_ PLEASE HELP!!! (http://www.go4expert.com/forums/sql-advice-help-t23210/)

cs30team2 6Sep2010 06:40

SQL advice_ PLEASE HELP!!!
 
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.

shabbir 6Sep2010 08:34

Re: SQL advice_ PLEASE HELP!!!
 
So what help you are looking for? Is the query not running, giving error or something else.

cs30team2 7Sep2010 07:08

Re: SQL advice_ PLEASE HELP!!!
 
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.


All times are GMT +5.5. The time now is 01:40.