Advertisement
Guest User

Untitled

a guest
Apr 8th, 2020
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.20 KB | None | 0 0
  1. SELECT SUM(salaryAmount) as total, name
  2. FROM coaches
  3. JOIN salarypayments
  4. ON salarypayments.coach_id=coaches.id
  5. GROUP BY coaches.name
  6. HAVING total > (SELECT AVG(salaryAmount) FROM salarypayments);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement