Display data - problem

[maverickmax77]

Hello

I am currently doing a small project and here is my table -

USER_ID TIME_START TIME_END NAME

1 1 2 MAX
2 3 7 MAX
3 5 6 PEPPER
4 1 7 SUE

Let say I want to know who is available between 4 and 5. Of course I know Pepper will be free at that time. I know max in the second row will not displayed as 4 and 5 are in the way but Max in the first row will be displayed. So I need to know how to automatically discard the same name out when carrying out the logical operations.

I would be very very grateful if you give me tip or help

Maverickmax77

 

[rtmpxr]

This is how I'll do it:

select name from <table> where ('04:00:00' between time_start and time_max) and ('05:00:00' between time_start and time_max)

Obs: time_start and time_max are defined as "time type" and the representation is "hh:mm:ss"