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
No, the Ticket History Role - Owner/Initiator/Recipient