--14,16
SELECT FinalOrder.[Department Name],FinalOrder.[Category Name],CAST(ROUND(100.00/FinalOrder.TotalPercent * FinalOrder.Pecent,0) AS INT) AS [Percentage] FROM
(SELECT d.Name AS [Department Name],c.Name AS [Category Name],COUNT(c.Id) AS Pecent,(SELECT COUNT(c1.Id) AS Pecent FROM Reports AS r1
JOIN Categories AS c1 ON c1.Id = r1.CategoryId
JOIN Departments AS d1 ON d1.Id = c1.DepartmentId
WHERE d1.Name = d.Name
GROUP BY d1.Id) AS TotalPercent FROM Reports AS r
JOIN Categories AS c ON c.Id = r.CategoryId
JOIN Departments AS d ON d.Id = c.DepartmentId
GROUP BY d.Name,c.Name
) AS FinalOrder
GROUP BY FinalOrder.[Department Name],FinalOrder.[Category Name],CAST(ROUND(100.00/FinalOrder.TotalPercent * FinalOrder.Pecent,0) AS INT)
ORDER BY FinalOrder.[Department Name],FinalOrder.[Category Name],Percentage