SELECT bkcx AS 报考车型
,COUNT(*) AS 报考人数
,注册人数=sum(case zt when 1 then 1 else 0 end)
,未注册人数=sum(case zt when 0 then 1 else 0 end)
,SUM(ccjfje + ccbjje + zcbjje) AS 交费金额
,SUM(jfjmje) AS 减免费用
FROM dbo.ds_ajj_student
GROUP BY bkcx
,COUNT(*) AS 报考人数
,注册人数=sum(case zt when 1 then 1 else 0 end)
,未注册人数=sum(case zt when 0 then 1 else 0 end)
,SUM(ccjfje + ccbjje + zcbjje) AS 交费金额
,SUM(jfjmje) AS 减免费用
FROM dbo.ds_ajj_student
GROUP BY bkcx
sum(case zt when 0 then 1 else 0 end ) AS 未注册人数
FROM dbo.ds_ajj_student
GROUP BY bkcx
,COUNT(*) AS 报考人数
,注册人数=sum(case zt when '在训' then 1 else 0 end)
,未注册人数=sum(case zt when '报考' then 1 else 0 end)
,SUM(ccjfje + ccbjje + zcbjje) AS 交费金额
,SUM(jfjmje) AS 减免费用
FROM dbo.ds_ajj_student
GROUP BY bkcx
SELECT bkcx AS 报考车型
,COUNT(*) AS 报考人数
,注册人数=sum(case when zt<>'报考' then 1 else 0 end)
,未注册人数=sum(case zt when '报考' then 1 else 0 end)
,SUM(ccjfje + ccbjje + zcbjje) AS 交费金额
,SUM(jfjmje) AS 减免费用
FROM dbo.ds_ajj_student
GROUP BY bkcx