DECLARE @CalculateAvg AS TABLE (Name NVARCHAR(50),
Draft_Total FLOAT,
Live_Total FLOAT,
Completed_Total FLOAT)
INSERT INTO @CalculateAvg(Name,
Draft_Total,
Live_Total,
Completed_Total)
VALUES ('Santhosh',100,200,300),
('Dani',100,200,300),
('Leo',100,200,300),
('Miltone',100,200,300),
('Santhosh',200,400,600),
('Dani',600,700,700),
('Leo',700,800,300),
('Miltone',700,800,800),
('Santhosh',100,200,300),
('Dani',600,500,400),
('Leo',400,600,600),
('Miltone',500,700,800)
DECLARE @Draft_Total INT = (SELECT SUM(Draft_Total) FROM @CalculateAvg )
DECLARE @Live_Total INT = (SELECT SUM(Live_Total) FROM @CalculateAvg )
DECLARE @Completed_Total INT = (SELECT SUM(Completed_Total) FROM @CalculateAvg )
SELECT ((SUM(Draft_Total) * 100 ) / @Draft_Total) Draft_Total,
((SUM(Live_Total)* 100) / @Live_Total)Live_Total ,
((SUM(Completed_Total) * 100 ) / @Completed_Total) Completed_Total
FROM @CalculateAvg