1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Sql database problem. Help please!

Discussion in 'MySQL' started by cs30team2, Sep 8, 2010.

  1. cs30team2

    cs30team2 New Member

    Joined:
    Aug 10, 2010
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    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!


     

Share This Page