Get Credit number

Question

create table #CR(id int,name varchar(max),CreditValue int,CreditDate datetime)
create table #DR(id int,name varchar(max),debitValue int,CreditDate datetime)

INSERT into #CR VALUES(1,'Jogi',5000,GETDATE())

INSERT into #CR VALUES(1,'Jogi',7000,GETDATE())

INSERT into #CR VALUES(1,'Jogi',9000,GETDATE())

insert INTO #DR VALUES(1,'Jogi',3000,GETDATE())

insert INTO #DR VALUES(1,'Jogi',4000,GETDATE())

insert INTO #DR VALUES(1,'Jogi',7000,GETDATE())

;WITH Debit(Name,ID,TotalSum) AS(select Name,ID,sum(debitValue) from #DR1 GROUP by id,Name),Credit(Name,ID,TotalSum) AS(select Name,ID,sum(CreditValue) from #CR1 GROUP by id,Name)select Debit.Name,Credit.TotalSum as CR,Debit.TotalSum as DR,(Credit.TotalSum-Debit.TotalSum) Balance  FROM Debit inner join Credit on Debit.Id=Credit.ID