CODE (SQL):
скопировать код в буфер обмена
скопировать код в буфер обмена
- SELECT DATE(DATA) AS theday, AVG( CAST(tem AS FLOAT(4,2)) ) AS avgtmp, AVG( CAST(vla AS FLOAT(4,2)) ) AS avgvla FROM pok7 WHERE DATE(DATA) BETWEEN '2013-05-23' AND '2013-05-26' GROUP BY theday