Global Sea Temperatures as on 18 Jul 2022

Joining key File#1 to File#2 = Country
Joining key File#2 to File#3 = City

I agree I could've put everything in one single CSV but I just wanted it to be organized.

Note: The SeaTemperatures.csv file needs data cleansing.

@kaggle.kkhandekar_global_sea_temperatures_18072022.cities


CREATE TABLE cities (
  "country" VARCHAR,
  "city" VARCHAR
);

@kaggle.kkhandekar_global_sea_temperatures_18072022.countries


CREATE TABLE countries (
  "continent" VARCHAR,
  "country" VARCHAR
);

@kaggle.kkhandekar_global_sea_temperatures_18072022.seatemperatures


CREATE TABLE seatemperatures (
  "city" VARCHAR,
  "currtemp" VARCHAR,
  "windspeed" VARCHAR,
  "humidity" VARCHAR
);