From: Fillman, Eric (HAL)
Sent: Friday, June 29, 2012 3:53 PM
To: Thompson, Sonya (HAL); Ruckman, Maurice (HAL)
Subject: Not sure if you'll need this or not...
But in case Therron wants to see if RTD is doing anything, you can run this query and get the total shore excursion and revenue by day.
select DATE_BOOKED, TOTAL_BOOKED, TOTAL_AMOUNT from
(
SELECT to_char(date_booked, 'MM/DD/YYYY, DAY') as DATE_BOOKED,
to_char( COUNT(to_char(date_booked, 'MM/DD/YYYY, DAY')), '999,999' ) as TOTAL_BOOKED,
to_char( sum( amt_price), '$9,999,999.00' ) as TOTAL_AMOUNT
FROM guest_shx
WHERE date_booked > '01-JUN-12'
GROUP BY to_char(date_booked, 'MM/DD/YYYY, DAY')
)
order by DATE_BOOKED
You can change the "where date_booked" as needed to get more days, fewer days, etc.
Thanks.
Eric