select
, grp_desc1,rp_desc1
, "" as grp_desc2
, "" as grp_description1
, "" as grp_description2
, sum(rpt_revenue_occupied) as rpt_revenue_occupied
, max(rpt_revenue_roomtype) as rpt_revenue_roomtype
, sum(rpt_revenue_adult) as rpt_revenue_adult
, sum(rpt_revenue_child) as rpt_revenue_child
, sum(add_bed) as add_bed
, sum(total_roomtype_beds) as total_roomtype_beds
, 1 as rpt_revenue_nights, sum(rpt_revenue_revenue) as rpt_revenue_revenue
, sum(rpt_revenue_other) as rpt_revenue_other
, max(total_roomtype_rooms) as total_roomtype_rooms
, max(z_roomtype_description) as z_roomtype_description from rep_revenue
WHERE rep_revenue.property = 'WONDER' and rep_revenue.rptdate>= '2007/08/02'
and rep_revenue.rptdate <= '2007/08/02'
group by rpt_revenue_roomtype
order by rpt_revenue_roomtype