如何根据子查询结果聚合数据

I have a sql query like this:

我有这样的SQL查询：

SELECT (SUM(DURATIONSECS) / 3600.00) AS LaborHrs, 
(SELECT LABORLEV2 t2 FROM LABOR WHERE LABORID = t1.LABORID) As Dept
FROM Table1 t1 
WHERE DTM BETWEEN 'datetime1' AND 'datetime2' AND 
(SELECT LABORLEV1 FROM LABOR WHERE LABORID = t1.LABORID) = '100' 
AND PAYCODEID='1'
Group BY LABORID
S