sql server need help for the below query

declare @tbl table

(name varchar(10),

datecol date,

col1 int,

col2 int,

col3 int

)

insert into @tbl

select 'KK','28-Mar-17',0,0,0

union all

select 'RK','29-Mar-17',45,31,111

union all

select 'MK','30-Mar-17',50,30,97

union all

select 'GK','31-Mar-17',45,34,105

union all

select 'KK','1-Apr-17',46,30,114

union all

select 'RK','2-Apr-17',0,0,0

union all

select 'MK','3-Apr-17',50,32,112

union all

select 'GK','4-Apr-17',53,40,164

union all

select 'RK','5-Apr-17',50,12,33

--select name,sum(col1),sum(col2),sum(col3) from @tbl

--group by name

select tbl.name,tbl2.col1,tbl2.col2,tbl2.col3,tbl3.ytdcol1,tbl3.ytdcol2,tbl3.ytdcol3 from (select name,max(datecol) as coldate from @tbl

group by name ) tbl

INNER join (select name,datecol,col1,col2,col3 from @tbl) tbl2 on

tbl.name=tbl2.name and tbl.coldate=tbl2.datecol

inner join (select name,sum(col1) ytdcol1,sum(col2)ytdcol2,sum(col3) ytdcol3 from @tbl

group by name) tbl3 on tbl.name=tbl3.name

order by tbl.name