how many cities are the aiports | Did you mean the number of cities that have any airport? | exactly
select count ( distinct city )  from airports
number of cities that have any airport refers to COUNT(DISTINCT city);