Can you tell me what is the total number of airlines in the United States that have an active status of "Y"?
SELECT COUNT ( * )  FROM airlines WHERE active   =   'Y' AND country  =  "United States"
total number = COUNT(*); airlines in the United States refers to country = 'United States'; active status of 'Y' refers to active = 'Y';