Thank you, that is very close. Unfortunately what I am trying to get to is a summary of customers and items from the Special_Orders table in relation to which trip they made to the location. So I need to see, using this data, is that 10 customers in the special_orders table are in there from items ordered on their first visit and 5 are in there from items ordered on their second visit. In the sample data I created, the first 10 made another order at the location at a later date but are not in special_orders for the second visit but rather the first, nor are the other 5 in there from their first visit, but rather their second. I'm not really concerned about location as it was just a way to join, along with customer. So I need to see something like this:

Visit_number Customers

1 10

2 5

Thanks for helping me out!