For our homework in our Computer science class, we were tasked to research by asking expert advice on database forums. We were first asked to download Census data to be analyzed using Microsoft Access. The data contained facts about 1% all people living in large US Cities at the time on the last US Census in the year 2000. The file gave the name of the city and the racial/ethnic ancestry of the person concerned.
I was able to achieve the objectives of the first task by illustrating the ff terms: fields, records, key fields, primary keys, foreign keys, relationship, and SQL.
To finish the task, we need to create a sorted list showing the number of Filipinos living in each city (with the cities with the largest number of Filipinos at the top).
I am not sure how to do this exactly. I need your advice on 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
The code is:
SELECT DISTINCTROW POPDATA.CITYNUM
COUNT (*) FROM POPDATA
WHERE POPDATA.ANCNUMBER=720
GROUP BY POPDATA.CITYNUM
ORDER BY COUNT (*) DESC;
Thank you so much! I would really appreciate your advice on this.
Btw, I posted this on another forum. I hope you don't think I'm spamming. This is really for our homework :(