Weather.csv

date Date	tavg Tavg	tmin Tmin	tmax Tmax	prcp Prcp	wdir Wdir	wspd Wspd	wpgt Wpgt	pres Pres
Sun Jan 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	9	5	17		37	2.9	11.1	1031.8
Mon Jan 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	8.5	4	13.9		54	3.5	9.3	1031.5
Tue Jan 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	8.1	4.3	15.6		62	5.2	9.3	1029.5
Wed Jan 04 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	9	5.4	15.2		58	4.1	14.8	1028.1
Thu Jan 05 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	8.5	3.9	15.2		75	4.4	13	1024.4
Fri Jan 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	8.3	3.8	16		33	4.2	14.8	1024.3
Sat Jan 07 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	7.2	2.6	15		62	6.1	14.8	1024.3
Sun Jan 08 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	7.2	2.2	13		85	4.4	9.3	1022.5
Mon Jan 09 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	11.4	9.6	13	44	132	10.9	20.4	1014.8
Tue Jan 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	9.9	6.7	12.6	14.6	287	9.1	16.7	1007.5


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