I work for a Theatre and I need to write a query to see if a patron has visited us more than once in a week. I have a table, let’s say [Visits] that has the [DateVisited],[TicketNum] and the [PatronID]. Who would I create a query to see if any patron visited more than once in a week. Given that the patron can buy more then one ticket per visit.
