Hello,

I am having a query,
I had a table named tblBooking
There exist 3 columns in that table
Column Names BookingID StartTime EndTime
Datatye int varchar varchar
Sample data 1 10:00 11:00
2 11:00 12:00
3 01:30 03:30

I need to compare values of two columns StartTime EndTime
Query is : I had to alloacte a resource eg. Meeting Room This can be done on daily basis between 10:00 am to 7:00 pm. So I need to check the availibility of Meeting room on basis of Time. Considering all scenarios.
This was a question asked to me in an interview which I ws u
nable to answer so I need to find the way hw to do it