ต้องการรวม จำนวนคนและ จำนวนเงิน ดังอธิบายข้างล่างค่ะ asp.net c#

WITH [AgentQuery] (AmtPeroid ,AgentCode, AgentName, ) AS
(
   SELECT AmtPeroid=dc.AmtPeroid, AgentCode=mg.AgentCode
      , AgentName=mg.AgentName
   FROM tbDCusCardS dc
   inner join tbMAgent mg 
      on dc.AgentID = mg.AgentID
   left join tbMUser mu 
      on mg.AgentCode = mu.UserName
   inner join tbMCardS mc 
      on dc.CardSNo = mc.CardSNo
)
SELECT COUNT([AgentCode]) As [Frequency]
   ,[AgentName]  AS [Name], SUM([AmtPeroid ])  AS [Amount]
FROM [AgentQuery] 
GROUP BY [AgentCode] ,[AgentName]