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)	8.8	1	17.2		352	2.2	1031.6
Mon Jan 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	9	-1	16.4		340	1.7	1031.2
Tue Jan 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	7.7	-0.6	16.1		354	2.7	1029.3
Wed Jan 04 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	7.4	0.4	16		3	5.3	1026.9
Thu Jan 05 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	7.2	0.4	15		357	2.7	1024.2
Fri Jan 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	7.9	0.2	16.4		6	3.8	1023.4
Sat Jan 07 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	8.1	-0.8	15.8		338	1.9	1023.5
Sun Jan 08 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	6.8	-1.8	15.4		349	1.7	1022.7
Mon Jan 09 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	7.8	0.2	11.8	45.3	185	4.6	1019.2
Tue Jan 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	8.4	5.4	10.8	31.5	355	3.6	1008.9


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