MSSQL Count, Percentage

SELECT Category, -- Replace with your actual column name for category COUNT(*) AS Count, CAST(COUNT(*) * 100.0 / SUM(COUNT(*)) OVER () AS decimal(10,2)) AS Percentage
FROM YourTable GROUP BY Category;

Result-------------------------

Category     Count     Percentage
M                    10                 10.0
W                    90                 90.0