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)	10.8	5	16.6		34	2.6	1022.3
Sun Jan 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	10.5	5.2	20		54	3.4	1023.8
Mon Jan 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	11.1	5.6	16.2	0.9	112	4.1	1021.1
Tue Jan 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	10.8	7.1	15.8	1.1	111	5.1	1017.7
Wed Jan 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	12.1	7.2	19		103	5.2	1011.4
Thu Jan 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	13	9.8	17.8	10.6	110	7.5	1010.1
Fri Jan 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	11.1	8.7	15	4.8	13	3.4	1013
Sat Jan 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	9.8	8	11.8	9	7	3.2	1009.7
Sun Jan 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	8.5	6.1	11	5.3	74	2.5	1003.9
Mon Jan 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	7.4	4.4	12	1.6	354	2.7	997.6


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