Advertisement
Guest User

Untitled

a guest
Dec 7th, 2016
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.46 KB | None | 0 0
  1.  SELECT Nameemployee, AVG(Cost)
  2. FROM Department o, Staff s,Promotions y, ComponentsPromotions p
  3. WHERE  o.IdDepartment =s.IdDepartment and s.IdStaff=y.IdStaff and y.IdPromotion=p.IdPromotion
  4. GROUP BY Nameemployee
  5. HAVING AVG(Cost) >(SELECT o1.IdDepartment ,AVG(Cost)
  6. FROM Department o1, Staff s1,Promotions y1, ComponentsPromotions p1
  7. WHERE  o1.IdDepartment =s1.IdDepartment and s1.IdStaff=y1.IdStaff and y1.IdPromotion=p1.IdPromotion
  8. GROUP BY o1.IdDepartment)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement