SQL使用分组查询并计算条数

sql分组查询使用COUNT计算每一组的条数并添加条件

SELECT
  f.jxlx,
  COUNT(*) AS 全部,
  COUNT( CASE WHEN ( f.zt = 1 ) THEN jxlx END ) AS 在线,
  COUNT( CASE WHEN ( f.zt = 2 ) THEN jxlx END ) AS 不在线 
FROM
  f_machine_user_equipment f
WHERE
  f.dqszgd = 1
GROUP BY
  f.jxlx