Calculate Monthly Occupancy based on Checkin Checkout dates

I have a problem I want to solve. I have a main table which is the reservations and has details of the guest. it has details like nationality, checkin date, biographical date etc. this also means tha...