Weather.csv

date Date	tavg Tavg	tmin Tmin	tmax Tmax	prcp Prcp	wdir Wdir	wspd Wspd	pres Pres
Sat Jan 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	8.7	-0.4	17		3	5.4	1021.9
Sun Jan 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	9.7	1	17.8		350	2.9	1024.3
Mon Jan 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	9.8	0.8	15.8	0.2	314	1.8	1022.2
Tue Jan 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	9.9	6.4	16	0.8	24	1.8	1018.9
Wed Jan 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	10.8	4	15	1.3	174	7	1015.1
Thu Jan 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	12.3	10.1	16	4.5	176	7.1	1012.5
Fri Jan 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	10.5	8.2	14	5.3	45	2.2	1013.8
Sat Jan 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	10	8.6	12.1	14.9	66	2.7	1010.3
Sun Jan 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	8.6	6.7	11.6	3.7	352	3.8	1004.2
Mon Jan 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	5.9	4	7.8	13.7	13	2.6	998.5


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