Name: Global Sea Temperatures - 18/07/2022
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

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
);