Hello smart friends.
I've been asked for the following information for the past 5 seasons:
Total single ticket sales (units sold, households, and revenue)
My first stab at getting the answers is this:
SELECT count (customer_no) cust_count, sum (num_seats) seat_qty, sum (tck_amt) revenueFROM T_TICKET_HISTORY THJOIN TR_PRICE_TYPE PT ON th.price_type = pt.idWHERE th.season = 280AND price_type_group IN (4,5)
And my result is this:
Any thoughts or advice on if I'm close to being able to answer this question? Anything else I should think about?
Thanks as always!
Lesley
You may want to restrict it by ticket history role, as well
Ooh, thanks! I JUST thought of that too.
That's the one that trips us up here all the time, so I thought I'd mention it
Can you tell me if it's only looking for "currently seated" orders, or if this is also including voo, vto, etc?