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)	9.8	1.4	18		131	3.6	1022.3
Sun Jan 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	9.9	2	19.6		109	4.4	1023.6
Mon Jan 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	10.2	1.6	17.2	0.6	210	3	1021.2
Tue Jan 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	10.6	6	17.4		124	3.3	1017.8
Wed Jan 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	11.4	4	20.6		138	9.5	1011.3
Thu Jan 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	12.5	3.2	19.8		130	10.1	1009.8
Fri Jan 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	10	6.4	16.2	1.2	116	3.6	1012.8
Sat Jan 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	9.4	7.2	12.2	6.8	24	3.6	1009.7
Sun Jan 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	8.2	5.1	11.2	4.6	158	3.7	1004.2
Mon Jan 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	7.3	3.8	12	2.5	119	5.3	997.6


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