• Replies 3 replies
  • Subscribers 413 subscribers
  • Views 33 views
  • Users 0 members are here
Related

Subs with Single Tickets

Amy Aldrich
$organization

Hello,

We did a promotion in which subscribers who bought single tickets in addition to their subscription will receive some free coupons for parking. They get one coupon per single concert they bought. I am having trouble finding this information.

I tried to make an extraction, but I can't yield the results I am looking for. I need to be able to break it down by subs who bought 5 or more single concerts, subs who bought 4 single concerts, 3, 2 and 1.

Anybody have any suggestions for getting these 5 different groups? We don't have T-stats yet.

Thanks in advance!

Parents
  • $organization

    CORRECTION:

     

    Try this instead:

     

    Select Distinct a.customer_no

     From t_customer a (NOLOCK)

    JOIN vs_subscription_hist e (NOLOCK) ON a.customer_no = e.customer_no

     Where  IsNull(a.inactive, 1) = 1

     AND e.season in  (46)

     AND  Exists (select customer_no from vs_tck_hist (NOLOCK)  Where vs_tck_hist.customer_no = a.customer_no and price_type = 'I' and season in  (46)  group by customer_no Having count(distinct convert(char(12), performance_dt) +  matinee_or_evening) =  2)

     

    Lucie

Reply
  • $organization

    CORRECTION:

     

    Try this instead:

     

    Select Distinct a.customer_no

     From t_customer a (NOLOCK)

    JOIN vs_subscription_hist e (NOLOCK) ON a.customer_no = e.customer_no

     Where  IsNull(a.inactive, 1) = 1

     AND e.season in  (46)

     AND  Exists (select customer_no from vs_tck_hist (NOLOCK)  Where vs_tck_hist.customer_no = a.customer_no and price_type = 'I' and season in  (46)  group by customer_no Having count(distinct convert(char(12), performance_dt) +  matinee_or_evening) =  2)

     

    Lucie

Children
No Data