Advertisement
Gesh4o

Untitled

Oct 13th, 2016
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. SELECT TOP 5 c.CustomerID, l.Amount FROM Customers AS c
  2. INNER JOIN Loans AS l ON l.CustomerID = c.CustomerID
  3. WHERE l.Amount > (SELECT AVG(l.Amount) FROM Loans AS l
  4. INNER JOIN Customers AS c ON c.CustomerID = l.CustomerID
  5. WHERE c.Gender = 'M')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement