Data from Weather Station test

Home
 

Rainfall in mm

SELECT Date(time), SUM(rain) FROM wx_data WHERE device_id = 3 AND rain > 1 AND Date(time) > '2020-12-31' GROUP BY DATE(time)
 
DATE(TIME)
SUM(RAIN)
2021-03-10  31 
2021-03-15  35 
2021-03-26 
2021-04-26 
2021-04-27 
2021-05-05 
2021-05-06 
2021-05-15  15 
2021-05-20  90 
2021-05-21  15 
2021-05-28  10 
2021-05-29 
2021-05-31 
2021-06-22  23 
2021-06-23 
2021-06-25  23 
2021-06-26 
2021-06-28  64 
2021-06-29  64 
2021-06-30  35 
2021-07-01 
2021-07-03  26 
2021-07-08  48 
2021-07-09 
2021-07-12  33 
2021-07-13 
2021-07-17 
2021-07-19 
2021-07-20 
2021-07-27  13 
2021-07-29 
2021-08-03  19 
2021-08-07 
2021-08-08  33 
2021-08-11 
2021-08-12 
2021-08-18  12 
2021-08-26  29 
2021-08-27 
2021-08-28 
2021-09-03  13 
2021-09-05 
2021-09-12 
2021-09-20 

 

Home