Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2010
    Posts
    2

    Unanswered: help with sql decoding

    hi! can anyone help us with the project assigned for us?

    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

    ---------------

    SELECT DISTICTROW POPDATA.CITYNUM,
    COUNT(*)FROM POPDATA
    WHERE POPDATA.ANCNUMBER=720
    GROUP BY POPDATA.CITYNUM
    ORDER BY COUNT(*) DESC;

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by cs30potato View Post
    hi! can anyone help us with the project assigned for us?
    yes, we can

    what have you tried?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Sep 2010
    Posts
    2
    the project assigned to us is not focused on the programming part, but on trying to get help from public forums. the professor expects us hopefullly to have someone read our forum post and help us. it would be really appreciated if you can decode it

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by cs30potato View Post
    it would be really appreciated if you can decode it
    of course i can decode it, the problem is rather straight-forward for anyone who knows SQL

    if--and i have not yet decided whether i will--if i give you a solution, then, would it matter if it actually worked?

    i thought so

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Please ask your professor or their assitant to contact me. I'd like to discuss this assignment with them so that I can understand what they want you to learn from it.

    With a "normal" assignment it is easy to understand what the instructor's intentions are, but this is unique. Don't be concerned about asking them to contact me, I'm certain that they are prepared for that request and are expecting it.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    this is at least the third thread on this topic
    http://www.dbforums.com/microsoft-ac...ly-needed.html
    I'd rather be riding on the Tiger 800 or the Norton

  7. #7
    Join Date
    Mar 2004
    Posts
    480
    Also posted the exact same on forums.mysql.com I just like how they cut and paste the instructions too!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •