SELECT
SELECT l.*
d.DEP_NAME, sq.LAB_CNT
FROM LABORING l
FROM DEPARTAMENT d,
LEFT JOIN LABORING b on (b.LAB_ID = l.LAB_BOSS_ID AND b.DEP_ID = l.DEP_ID)
WHERE b.LAB_ID IS NULL