For me this looks like a problem of getting the days(s) with most items booked. Getting all days in a period is easy with a CTE, from there you can...