Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE flight ( id int, Vehicle_Flight_number text, Date text, Pilot text, Velocity real, Altitude real, airport_id int, company_id int )
TABLE: CREATE TABLE operate_company ( id int, name text, Type text, Principal_activities text, Incorporated_in text, Group_Equity_Shareholding real )
TABLE: CREATE TABLE airport ( id int, City text, Country text, IATA text, ICAO text, name text )

### Question ###
Show me the total number by country in a histogram

### Accurate SQL ###

SELECT Country, COUNT(*) FROM airport GROUP BY Country