Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT TOP 5 c.CustomerID, l.Amount FROM Customers AS c
- INNER JOIN Loans AS l ON l.CustomerID = c.CustomerID
- WHERE l.Amount > (SELECT AVG(l.Amount) FROM Loans AS l
- INNER JOIN Customers AS c ON c.CustomerID = l.CustomerID
- WHERE c.Gender = 'M')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement