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
GROUP BY POPDATA.CITYNUM
ORDER BY COUNT (*) DESC[/td]
I really have no idea how to do it so if you could please help me, I would appreciate it! Thank you!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!