将“ Count（*）”占“ GROUP BY”中所有项目数的百分比

将“ Count（*）”占“ GROUP BY”中所有项目数的百分比

SELECt Category, COUNT(*) AS Total , (COUNT(*) / (SELECT COUNT(*) FROM Item WHERe Department='Popular')) * 100 AS 'Percentage to all items', FROM ItemWHERe Department='Popular'GROUP BY Category;

我不确定MySql的语法，但是可以使用如图所示的子查询。