Advertisement
Guest User

Untitled

a guest
Jan 22nd, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. SELECT nume, prenume
  2. FROM Angajati
  3. WHERE AngajatID IN (
  4. SELECT ManagerID
  5. FROM Departamente
  6. WHERE DepartamentID IN (
  7. SELECT DepartamentID
  8. FROM Poiecte
  9. WHERE ProiectID IN (
  10. SELECT ProiectID
  11. FROM AngajatiProiecte
  12. GROUP BY ProiectID
  13. HAVING SUM(ore) > 100
  14. )
  15. GROUP BY DepartamentID
  16. HAVING COUNT(ProiectID) >= 3
  17.  
  18. )
  19. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement