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)	11.2	6	18.4		91	9.8	1016.3
Sun Jan 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	12.3	7.4	18.2	2.1	130	8	1014.5
Mon Jan 04 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	9.2	7.5	11.4	14.9	132	5.8	1010.9
Tue Jan 05 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	9.8	7	15.2	2.2	135	8.6	1014.8
Wed Jan 06 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	10.6	9.9	12	13.3	141	13.9	1016.7
Thu Jan 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	10.8	9.3	12.4	37.3	120	6.9	1014.5
Fri Jan 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	13.4	11.2	16.6	42.7	150	9.4	1008.8
Sat Jan 09 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	11.8	10.6	14.4	9.4	333	2.8	1011.9
Sun Jan 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	13.9	10	17.4	16.4	73	5.9	1010.3


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