Get Credit number

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