select p.seq as plantSeq, p.name as plantName, p.supplyPower, min(d.data15) as data15Min, max(d.data15) as data15Max, round(avg(d.data15)) as data15Avg, d.data32, d.data33, min(d.pvPower) as pvPowerMin, max(d.pvPower) as pvPowerMax, round(avg(d.pvPower)) as pvPowerAvg, (select count(seq) from t_timetable_pms t where t.inputDate between #{startDate} and #{endDate} ) as pmsCnt, (select count(seq) from t_pmsdata_2020 m where d.plantSeq = m.plantSeq and m.inputDate between #{startDate} and #{endDate} and (m.data25 > 0 or m.data62 > 0 or m.data63 > 0 or m.data64 > 0 or m.data25 > 0 or m.data62 > 0 or m.data63 > 0 or m.data64 > 0)) as pmsFailCnt, (select count(seq) from t_kesco_data k where d.plantSeq = k.plantSeq and k.inputDate between #{startDate} and #{endDate} ) as kescoCnt, (select count(k.seq) from t_kesco_data k where d.plantSeq = k.plantSeq and k.inputDate between #{startDate} and #{endDate} and returnResult <> 'ok' ) as kescoFailCnt from t_plant p, t_pmsdata_statistic_day d where p.seq = d.plantSeq and inputDate between #{startDate} and #{endDate} group by p.seq