Hello awesome people,
I am stuck with this problem where I have records of hotel bookings, where I need to find the bookings that happened for a particular day. For eg, A booked hotel from Jan 1 - Jan 5, B booked the same hotel from Jan 3 - Jan5 and C booked the hotel for Jan 3. I would like to know the number of bookings for Jan 3 and the count should be Count = 3.
The table has a booking id, from date to date as columns. What do you think is the best way to approach this problem to find out the count for January 3rd?