SQL Query finding range an overlaps another booking (Time):

SELECT COUNT(*) FORM Table_name WHERE NOT ('8:00:00' > Table.endtime OR '9:40:00' < Table.starttime)

Reference: http://stackoverflow.com/questions/