@Query("SELECT NEW com.trading.crawlingtradinginfo.tradingMVC.model.VolumePowerResultDTO(vp.korean_name AS korean_name, " + "SUM(CASE WHEN vp.power = '상위' THEN 1 ELSE 0 END) AS topCnt, " + "SUM(CASE WHEN vp.power = '하위' THEN 1 ELSE 0 END) AS bottomCnt) " + "FROM volume_power vp " + "WHERE STR_TO_DATE(vp.id.insert_dt, '%Y%m%d%H%i') >= STR_TO_DATE(:#{#dateRangeDTO.startDt}, '%Y%m%d%H%i') " + "AND ..