SELECT LEFT(packet_date,10) AS day, ROUND(AVG(windAverageMS0),1) AS windTower, ROUND(AVG(windAverageContainer),1) AS windContainer FROM view_A3351_building GROUP BY LEFT(packet_date,10) ORDER BY LEFT(packet_date,10)
