t_weather_2021 select p.seq as plantSeq, p.name as plantName, w.* from w, t_plant p where w.weatherCode = p.weatherCode and p.plantStatus='01' and inputYmd= #{inputYmd} and w.inputHour = ( select max(inputHour) from where inputYmd=#{inputYmd} and inputHour <= #{inputHour} ) and w.inputHour = ( select max(inputHour) from where inputYmd=#{inputYmd} ) and p.seq = #{plantSeq} order by p.seq desc select inputHour, count(inputHour) as count from where inputYmd = #{inputYmd} group by inputHour order by inputHour desc select p.seq as plantSeq, p.name as plantName, w.* from w, t_plant p where w.weatherCode = p.weatherCode and p.plantStatus='01' and inputYmd= #{inputYmd} and p.seq = #{plantSeq} order by w.inputHour desc select inputYmd, inputHour, count(weatherCode) as count from where inputYmd = #{inputYmd} group by inputYmd, inputHour select inputYmd, inputHour, count(inputYmd) as count from where inputYmd = #{inputYmd} and inputHour = ( select max(inputHour) from where inputYmd = #{inputYmd} )