select grp_desc1 rp_desc1 as grp_desc2 as grp_description1 as grp_desc

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
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