How many airports are in the United States?
SELECT count ( * )  from airport where country  =  "United States"
airports in the United States refers to filtering airport table where country equals 'United States'; count of airports is achieved using COUNT(*) function;