declare @t table (PRODUCT varchar(10), AGE tinyint, COMPANY varchar(10), SALARY smallint)

insert @t
(PRODUCT, AGE, COMPANY, SALARY)
values
	('Appple',32,'Ahmedabad',2000),
	('Banana',25,'Delhi',1500),
	('Banana',23,'Kota',2000),
	('Orange',25,'Mumbai',6500),
	('Grapes',27,'Bhopal',2500),
	('Orange',22,'MP',4500),
	('Orange',24,'Indore',10000)

select
	PRODUCT, AGE, COMPANY, SALARY
from
	(
	select
		PRODUCT, null as AGE, null as COMPANY, sum(SALARY) as SALARY, row_number() over(order by sum(SALARY) desc) as rn
	from
		@t
	group by
		PRODUCT
	union all
	select
		PRODUCT, AGE, COMPANY, SALARY, null as rn
	from
		@t
	)q
order by
	max(rn) over(partition by PRODUCT), SALARY desc

declare @t table (PRODUCT varchar(10), AGE tinyint, COMPANY varchar(10), SALARY smallint)
declare @Q table (PRODUCT varchar(10), AGE tinyint, COMPANY varchar(10), S_SALARY smallint)

insert @t
(PRODUCT, AGE, COMPANY, SALARY)
values
	('Appple',32,'Ahmedabad',2000),
	('Banana',25,'Delhi',1500),
	('Banana',23,'Kota',2000),
	('Orange',25,'Mumbai',6500),
	('Grapes',27,'Bhopal',2500),
	('Orange',22,'MP',4500),
	('Orange',24,'Indore',10000)

insert @Q
(PRODUCT, AGE, COMPANY, S_SALARY)
select
	PRODUCT, null as AGE, null as COMPANY, sum(SALARY) as S_SALARY
from
	@t
group by
	PRODUCT

select
	PRODUCT, AGE, COMPANY, SALARY
from
	(
	select
		PRODUCT, null as AGE, null as COMPANY, S_SALARY as SALARY, S_SALARY
	from
		@Q
	union all
	select
		t1.PRODUCT, t1.AGE, t1.COMPANY, t1.SALARY, t2.S_SALARY
	from
		@t t1
		inner join @Q t2 on t2.PRODUCT = t1.PRODUCT
	)q
order by
	S_SALARY desc, SALARY desc

declare @t table (PRODUCT varchar(10), AGE tinyint, COMPANY varchar(10), SALARY bigint)
declare @Q table (ID int identity, PRODUCT varchar(10), AGE tinyint, COMPANY varchar(10), S_SALARY bigint)

insert @t
(PRODUCT, AGE, COMPANY, SALARY)
values
	('Appple',32,'Ahmedabad',2000),
	('Banana',25,'Delhi',1500),
	('Banana',23,'Kota',2000),
	('Orange',25,'Mumbai',6500),
	('Grapes',27,'Bhopal',2500),
	('Orange',22,'MP',4500),
	('Orange',24,'Indore',10000),
	('Banana2',25,'Delhi',1500),
	('Banana2',23,'Kota',2000)

insert @Q
(PRODUCT, AGE, COMPANY, S_SALARY)
select
	PRODUCT, null as AGE, null as COMPANY, sum(SALARY) as S_SALARY
from
	@t
group by
	PRODUCT

select
	PRODUCT, AGE, COMPANY, SALARY
from
	(
	select
		PRODUCT, null as AGE, null as COMPANY, S_SALARY as SALARY, S_SALARY * power(10,6) + ID as ID
	from
		@Q
	union all
	select
		t1.PRODUCT, t1.AGE, t1.COMPANY, t1.SALARY, t2.S_SALARY * power(10,6) + ID
	from
		@t t1
		inner join @Q t2 on t2.PRODUCT = t1.PRODUCT
	)q
order by
	ID desc, SALARY desc, AGE