Having - Patrons with count of tickets

The query is based on ticket data for a patron and you can add other criteria such as:

• Only specific shows in the past
• A certain fiscal year, season or range of seasons
• People who have donated money in the past and are large purchasers
• patrons who paid for their tickets (eg total cost > 0)

The example below shows the user of Ticket Quantity from the ticket data per performance in the having clause to obtain people who bought more than 20 tickets (in all time). The first line of criteria was added to make sure that they were Paid tickets and not comps.