Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MySQL (http://www.go4expert.com/forums/mysql-forum/)
-   -   Sql database problem. Help please! (http://www.go4expert.com/forums/sql-database-help-t23252/)

cs30team2 8Sep2010 19:16

Sql database problem. Help please!
 
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
__________________________________________________

Good Day!

Given that we are not programming majors, we would like to request assistance on how to get the complete solution for this task.

We would very much appreciate anyone who could help us fulfill this task.

THANK YOU!




All times are GMT +5.5. The time now is 13:17.