1. SELECT      DATE_FORMAT(MDATE, '%Y-%m') AS Month,   
   AVG(CAST(TEMPERATURE AS DECIMAL(5,2))) AS Avg_Temperature FROM METEO  WHERE YEAR(MDATE) = 2017 GROUP BY Month ORDER BY Month;
2. 
