I have a Scheduler (calendar). I would like to find all those instances when the first timeslot each day is occupied. I do not know at what time the first timeslot starts.
I have all timeslots in 1 table:
And occupied timeslots in another:
How is best to do this?