Weather.csv

date Date	tavg Tavg	tmin Tmin	tmax Tmax	prcp Prcp	wdir Wdir	wspd Wspd	pres Pres
Fri Jan 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)
Sat Jan 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	8.8	1	14.4	0.7	76	3.4	1018.2
Sun Jan 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	10.8	8.7	15.6	12	160	4.2	1016.6
Mon Jan 04 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	8.3	5.2	11.4	52.4	24	3.6	1011.9
Tue Jan 05 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	7	3.7	9.9	5.9	70	2.2	1016.6
Wed Jan 06 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	9.4	7.6	12.4	36.1	192	4.8	1019.1
Thu Jan 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	10.7	8.6	12.7	88.8	212	4.4	1016.5
Fri Jan 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	13.2	11	15	57.8	195	5.8	1011.6
Sat Jan 09 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	13.2	10.4	16	15.2	279	5.3	1012.2
Sun Jan 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	15.2	12.9	18.8	16	181	4.6	1013.3


CREATE TABLE sarande2021 (
  "date" TIMESTAMP,
  "tavg" DOUBLE,
  "tmin" DOUBLE,
  "tmax" DOUBLE,
  "prcp" DOUBLE,
  "snow" VARCHAR,
  "wdir" DOUBLE,
  "wspd" DOUBLE,
  "wpgt" VARCHAR,
  "pres" DOUBLE,
  "tsun" VARCHAR
);