StoyanGrigorov

Problem 10 Bank 100/100

Feb 5th, 2017
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.31 KB | None | 0 0
  1. CREATE PROCEDURE usp_GetHoldersWithBalanceHigherThan(@TargetBalance MONEY)
  2. AS
  3. BEGIN
  4.     SELECT a.FirstName AS 'First Name', a.LastName AS 'Last Name' FROM AccountHolders AS a
  5.     INNER JOIN Accounts AS ac
  6.     ON a.Id = ac.AccountHolderId
  7.     GROUP BY a.FirstName, a.LastName
  8.     HAVING SUM(ac.Balance) > @TargetBalance
  9. END
Add Comment
Please, Sign In to add comment