CREATE OR ALTER PROC usp_GetHoldersWithBalanceHigherThan(@amount MONEY)
AS
BEGIN
SELECT ah.FirstName, ah.LastName FROM AccountHolders AS ah
JOIN Accounts AS a ON ah.Id = a.AccountHolderId
GROUP BY ah.FirstName, ah.LastName
HAVING SUM(a.Balance) > @amount
ORDER BY ah.FirstName, ah.LastName
END