求一条sql语句？

[llh6795]

select '2010-09-09',count(*) as zaob,employeeid from lsb201009 where datetimebrush between '2010-09-09 06:00:00.000 ' and '2010-09-09 18:30:00.000' and worktypename='倒班' group by employeeid having count(*)>=2
这个的意思是在‘2010-09-09 06:00:00.000’ 和'2010-09-09 18:30:00.000' 之间有两个以上的记录，我还想加个条件在这句里面，满足前面那个条件并且在‘2010-09-09 18:31:00.000'和'2010-09-10 05:59:00.000' 之间没有记录的数据？
就是要满足两个条件《1》在当天的06:00---18:30有两个以上记录 《2》满足第一个条件的同时还要满足当天18:31---次日
05:59 没有记录的数据，请大家指教？

[百年树人]

select '2010-09-09',count(*) as zaob,employeeid
from lsb201009 t
where datetimebrush between '2010-09-09 06:00:00.000 ' and '2010-09-09 18:30:00.000' and worktypename='倒班'
and
not exists(select 1 from lsb201009 where employeeid=t.employeeid and datetimebrush between '2010-09-09 18:31:00.000' and '2010-09-10 05:59:00.000')
group by employeeid
having count(*)>=2

[llh6795]

谢谢！