SELECT station_STN, yearmody, ROUND(AVG(temperature), 1) AS temperature FROM Parameters WHERE yearmody >= date_sub(‘2019-01-03’, 7) AND yearmody <= date_sub(‘2019-01-12’, 1) GROUP BY station_STN, yearmody limit 5;