SELECT count(*) ,  country FROM airport GROUP BY country
SELECT count(*) ,  country FROM airport GROUP BY country <table_name> : airport col : id | City | Country | IATA | ICAO | name row 1 : 1 | Akureyri | Iceland | AEY | BIAR | Akureyri Airport row 2 : 2 | Amsterdam | Netherlands | AMS | EHAM | Schiphol Airport row 3 : 3 | Anchorage | United States | ANC | PANC | Ted Stevens Airport row 4 : 4 | Baltimore | United States | BWI | KBWI | Baltimore-Washington Airport row 5 : 5 | Barcelona | Spain | BCN | LEBL | El Prat Airport row 6 : 6 | Bergen | Norway | BGO | ENBR | Bergen Airport row 7 : 7 | Billund | Denmark | BLL | EKBI | Billund Airport row 8 : 8 | Boston | United States | BOS | KBOS | Logan International Airport row 9 : 9 | Brussels | Belgium | BRU | EBBR | National Airport
col : count(*) | Country row 1 : 1 | Belgium row 2 : 1 | Denmark row 3 : 1 | Iceland row 4 : 1 | Netherlands row 5 : 1 | Norway row 6 : 1 | Spain row 7 : 3 | United States