SELECT A.ht_mst_seq
           ,A.ht_room_info_seq
           ,B.*
           ,max(A.max_cnt) as max_cnt
           ,max(A.min_cnt) as min_cnt
           ,max(A.meals_yn) as meals_yn
           ,min(A.price) AS min_price
FROM HT_ROOM A
INNER JOIN HT_ROOM_INFO B ON A.ht_room_info_seq = B.ht_room_info_seq
WHERE A.day > :to_day
AND A.ba_comp_seq = :channel_comp_seq
AND A.ht_mst_seq = :ht_mst_seq
AND A.view_yn = 'Y'
GROUP BY A.ht_mst_seq,room_type,B.ht_room_info_seq
ORDER BY min(A.price) ASC