常见条件聚合：

SELECT `emp-id`,
       SUM(status = 'Open') `Open`,
       SUM(status = 'Pending') `Pending`,
       SUM(status = 'Resolved') `Resolved`
FROM source_table
GROUP BY 1;

试试这样的方法：

SELECT empid,
       COUNT(CASE WHEN status = 'Open' THEN 1 END) `open`,
       COUNT(CASE WHEN status = 'Pending' THEN 1 END) `pending`,
       COUNT(CASE WHEN status = 'Resolved' THEN 1 END) `resolved`
FROM sampletable
GROUP BY empid;

Goodle为“pivot mySQL”提供其他解决方案。