Iam_Sandeep

Untitled

May 15th, 2026
36
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.15 KB | None | 0 0
  1. SELECT c.NAME
  2. FROM COMPANY c
  3. JOIN EMPLOYEE e ON c.ID = e.COMPANY_ID
  4. JOIN SALARY s ON e.ID = s.EMPLOYEE_ID
  5. GROUP BY c.NAME
  6. HAVING AVG(s.SALARY) > 40000;
Advertisement
Add Comment
Please, Sign In to add comment