I have a table in like this on SQL database, need help to select from table.
City State Population
Abbeville LA 12,103
Abbeville SC 5,547
Aberdeen NC 5,627
Aberdeen SD 24,460
Aberdeen WA 16,042
Aberdeen MD 13,993
Aberdeen MS 6,089
Abilene TX 116,484
Abilene KS 6,400
Abingdon VA 8,009
Absecon NJ 8,389
Acworth GA 19,476
Ada OH 6,052
Ada OK 16,729
Adamsville AL 4,739
Addison IL 36,917
Addison TX 14,964
Adel GA 5,396
Adel IA 4,428
a. Select the top 10 highest populated cities in descending order
b. Select the top 10 lowest populated cities in ascending order
c. Select the population sum of all cities grouped by state (show State and Population) and order by total population in descending order