Refer below query.

CREATE TABLE #Details
(
    [ID] int IDENTITY(1,1) NOT NULL,
    [Category] VARCHAR(50),
    [SubCategory] VARCHAR(50),
    [Price] DECIMAL(18,2),
    [Date] DateTime
)
 
INSERT INTO #Details VALUES ('Cloth','Female',3,'2019/03/04')
INSERT INTO #Details VALUES ('Car','Toyota',2000,'2019/03/04')
INSERT INTO #Details VALUES ('Cloth','Male',9,'2019/03/04')
INSERT INTO #Details VALUES ('Car','Honder',3000,'2019/03/04')
INSERT INTO #Details VALUES ('Cloth','Coporate wear',123,'2019/03/05')
 
 
SELECT Category,SUM(Price) AS Price,Date FROM #Details
GROUP BY Category,Date
ORDER BY Category DESC
 
DROP TABLE #Details