SQL SELECT(初学者)

你可以使用NOT EXISTS:

SELECT id_dep , name_dep
FROM department AS d
WHERE NOT EXISTS (SELECT 1 
                  FROM employee AS e
                  WHERE e.id_dep = d.id_dep AND e.salary >=  7000)