Extra Credit Exercise $9-3$

$(0\mathrm{.}5$ points$)20$ minutes

Retrieve

Distinct City and State Names

total # of recruiters

total, average, min, and max # of recruits

$-4.$ where city name has a term $"$or$"$

ascending order by City Name

cIr

$\backslash$table$[[$City$,$State,CityPopulation$],[$Portand$,$ME$,70\mathrm{.}000],[$Grand Rapids,MI$,190,000],[$Rockiord$,$in$,340,000],[$Spokane$,$WA$,210,000],[$Portland$,$OR$,600,000],[$Eugene$,$OR$,360,000],[$Grand Rapids,MV$,11\mathrm{.}000]]$