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

SQL advice_ PLEASE HELP!!!

Discussion in 'SQL Server' started by cs30team2, Sep 6, 2010.

  1. cs30team2

    cs30team2 New Member

    Joined:
    Aug 10, 2010
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    [FONT=&quot]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.
    [/FONT]​
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,287
    Likes Received:
    364
    Trophy Points:
    83
    So what help you are looking for? Is the query not running, giving error or something else.
     
  3. 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.

    [FONT=&quot]SELECT DISTINCTROW POPDATA.CITYNUM,
    COUNT(*)FROM POPDATA
    WHERE POPDATA.ANCNUMBER=720
    GROUP BY POPDATA.CITYNUM
    ORDER BY COUNT(*) DESC;

    [/FONT]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.
     

Share This Page