I have a table Input_Table defined like below
create table Input_Table(id int, [year] varchar(100),initial int,final int)
insert into Input_table values(1,'2017',1,11)
insert into Input_table values(2,'2017',8,11)
insert into Input_table values(3,'2017',3,33)
insert into Input_table values(4,'2016',6,44)
insert into Input_table values(5,'2016',6,44)
insert into Input_table values(6,'2017',6,44)
insert into Input_table values(7,'2016',4,8)
insert into Input_table values(8,'2017',2,8)
I need to get the output based on the requirement shown in the pic without using pivot or JOINs