need help for specific SQL problem

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

need help for specific SQL problem

Author

Topic

cs30team2
Starting Member

1 Post

Posted - 2010-09-08 : 10:44:40

Hi
We're tasked to solve this problem for our computer science class.
Anyone care to explain?

Our team needs to adapt the fragment of code below to show:
1) Two columns: the Filipino Population and Total Population
2) The Filipino Population as a percentage of the total population

Here's the code:
SELECT DISTICNTROW POPDATA. CITYNUM
COUNT(*) FROM POPDATA
WHERE POPDATA.ANCNUMBER=720
GROUP BY POPDATA.CITYNUM
ORDER BY COUNT (*) DESC;

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources