如果条件满足，则选择、检查和插入

I have the following tables: Tour, Customer, TourCustomerXRef. Assuming every Tour has a capacity Cap. Now a request arrives at the backend for a booking.I have the following tables: Tour, Customer, To