World Geographic And Climatic Dataset

CREATE TABLE capital_cities (
  "continent" VARCHAR,
  "country" VARCHAR,
  "capital_city" VARCHAR,
  "capital_population" BIGINT
);

CREATE TABLE greenhouse_emission (
  "country" VARCHAR,
  "total_co2" VARCHAR,
  "co2_per_capita" VARCHAR,
  "total_methane" VARCHAR,
  "methane_per_capita" VARCHAR
);

CREATE TABLE mega_cities (
  "mega_city" VARCHAR,
  "country" VARCHAR,
  "population" BIGINT
);

CREATE TABLE mountain_ranges (
  "mountain_range" VARCHAR,
  "highest_mount" VARCHAR,
  "height" BIGINT,
  "countries" VARCHAR
);