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;

yes, we can

what have you tried?

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

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

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

this is at least the third thread on this topic
help really needed.

Also posted the exact same on forums.mysql.com I just like how they cut and paste the instructions too!