so our computer science professor to create a database for the population of Filipinos in the USA. Now, he's asking us to complete the 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 DISTINCTROW POPDATA. CITYNUM, COUNT (*) FROM POPDATA WHERE POPDATA. ANCNUMBER=720 GROUP BY POPDATA. CITYNUM ORDER BY COUNT (*) DESC; Can anyone please explain how to solve this? Thank you!
here's the first part of our activity. the database files are there. sorry i dont know why i cant post links, it always says contact administrator too much links so here it is http://sendspace.com/file/5693nb
The reason you cannot post links is you have too few posts and this is done to stop spam. I have linked to your file as of now and get more posts and this message will go away.