SELECT nume, prenume, cnp
FROM Angajat
WHERE cnp NOT IN (
	SELECT cnpmanager
	FROM Departament
		UNION
	SELECT DISTINCT cnpa
	FROM intretinut
		UNION
	SELECT cnp
	FROM Angajat
	WHERE cnps IS NOT NULL
) AND cnp IN (
	SELECT cnp
	FROM lucreaza
	WHERE ore > 10 AND p_nr IN (
		SELECT p_nr
		FROM lucreaza
		GROUP BY p_nr
		HAVING COUNT(cnp) >= 10 AND SUM(ore) > 100
	)
	GROUP BY cnp
	HAVING COUNT(p_nr) >= 4
)