Guest User

Untitled

a guest
Jan 24th, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.25 KB | None | 0 0
  1. SELECT PaymentTotal, (SELECT ROUND(AVG(PaymentTotal),2)  FROM Invoice e_inner
  2. WHERE e_inner.PaymentTotal = e.PaymentTotal) AS avg_pay WHERE PaymentTotal > (SELECT ROUND(AVG)PaymentTotal),2) FROM Invoice e_inner WHERE e_inner.PaymentTotal = e.PaymentTotal;
Add Comment
Please, Sign In to add comment