10.People with Balance Higher Than

CREATE PROCEDURE usp_GetHoldersWithBalanceHigherThan (@value DECIMAL(14,2)) AS
BEGIN
    WITH CTE_TotalBalances(AccountHolderId) AS(
        SELECT AccountHolderId
         FROM Accounts
     GROUP BY AccountHolderId
       HAVING SUM(Balance) > @value
    )

    SELECT ah.FirstName, ah.LastName
      FROM AccountHolders AS ah
      JOIN CTE_TotalBalances AS cci
        ON cci.AccountHolderId = ah.Id
END