SELECt COUNT(1) FROM T_TABLE t WHERe (t.START_TIME >= '2021-09-29 11:00:00' AND t.START_TIME <= '2021-09-29 17:00:00' ) OR (t.START_TIME <= '2021-09-29 11:00:00' AND t.END_TIME >= '2021-09-29 17:00:00' ) OR (t.END_TIME >= '2021-09-29 11:00:00' AND t.END_TIME <= '2021-09-29 17:00:00' )



