Can you show me the total number of airports?
select count ( apid ) from airports
How about the total number of cities?
select count ( distinct city ) from airports
Can you sort them by the number of airports?
select city from airports group by city having count ( * ) > 2 order by count ( * )