event_name
Lights concert
event_time
5:30 pm
event_name
Movie show
event_time
10:30 pm
count
2
available_start_time
8 am
available_end_time
11 am
count
2
I want to check my calender for events. The date I want to look into is the 12th of March. You have Lights concert happening at 5:30 pm that day. Are there any other events scheduled for me? What about the 13th? Yes, you have 2 events scheduled on that day as well. You have Movie show which starts at 10:30 pm. Okay, sounds good! What days are available? There's 2 empty slots on the calender. You have an empty one from 8 am to 11 am, from what I can see here.
Alrighty, perfect. That's all I need to know.
You're welcome, have a nice day!