Hi - I'm working on a program that will tell me by zone and price event how many tickets are being sold. I'm looking into whether or not we are selling any tickets at all at our base prices or whether we are setting a base price, not waiting for any single tickets to sell at that price but then raising them. However, I'm running into two issues:
- First, if I group on start price (the first price built) I duplicate data in situations where we started with price A, sold no tickets, went up to price A+1 - sold few ticket and then went back to price A (so it's in T_PRICE_EVENT twice) the tickets duplicate so I end up over.
- Second, when I try to group on the price event, I can't seem to get sql to count and total the tickets sold less than or equal to the date of the price event.
For example, I have a table that says Zone A was sold at $50 starting on 1/1/2015 then in the next row Zone A for that same performance was sold at $55 on 1/3/2015 then in row 3 that same zone for that same performance was sold back down at $50 on 1/6/2015. Grouping orders on those dates in column is somehow causing me to miss a bunch of ticket (order_dt <= start_dt of the price event).
I'm not sure what i'm missing, but if anyone has an idea I'd be grateful. Thanks!
RJ