select g1.good_nm,g1.good_cd, (g1.min_adult_price) as adult_price, (g1.max_adult_price) as normal_price, g1.remark, (g1.tour_city) as area_remark, ltrim(g1.web_type_cd) as web_type_cd, g1.day_cnt from go1100 g1 where g1.good_type_cd ='O2' and right(g1.area_cd,1) = 'N' and g1.area_detail_cd = 'O2NN037' and (g1.web_type_cd <> '99' or g1.web_type_cd is null) and g1.good_added in ('F','G','H') Group By g1.good_nm,g1.remark,g1.good_cd,g1.tour_city,ltrim(g1.web_type_cd), g1.good_type_cd ,g1.area_cd ,g1.good_seq, g1.min_adult_price, g1.max_adult_price, g1.sort_order, g1.day_cnt ORDER BY g1.area_cd, g1.sort_order