Weather.csv

date Date	tavg Tavg	tmin Tmin	tmax Tmax	prcp Prcp	wdir Wdir	wspd Wspd	pres Pres
Sun Jan 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	12.3	8.2	18.4		48	2.1	1030.9
Mon Jan 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	11.9	7.2	17.4		53	3.1	1030.3
Tue Jan 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	11.7	8	17.8		46	2.7	1028.8
Wed Jan 04 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	11.3	7.5	16.2		52	2.8	1026.7
Thu Jan 05 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	10.5	7	16.8		77	2.9	1023.6
Fri Jan 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	10.7	5.6	17.2		44	2.9	1023.1
Sat Jan 07 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	9.5	4.7	16.8		46	2.8	1023
Sun Jan 08 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	10	5.6	16.8		116	4	1021.8
Mon Jan 09 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	12.1	8.4	15.4	20.2	135	12.8	1014.9
Tue Jan 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	9.8	6	14.8	16.9	107	8.4	1007.3


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