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,
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
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.
|All times are GMT +5.5. The time now is 10:45.|