SQL-CASEWhen使用

SELECT industryname,domaintype
,COUNT(domaintype) AS buscount,t1.total
--,SUM(buscount) AS total
FROM (
select ii.industryname as industryname,ii.industryid,d.setup_date,--d.busdomain_id,
CASE mm.memberlevelid WHEN '1' THEN '个人圈'
ELSE '公司圈'
END AS domaintype
from emk_business_domain d,emk_business_member m,
EMK_MEMCO_MEMBERINFO mm,
EMK_BUSINESS_INDUSTRY i,industry ii
WHERE d.busdomain_id=m.busdomain_id
AND mm.memberid=m.memberid
AND i.busdomain_id=d.busdomain_id
AND ii.industryid=i.fir_industry
AND d.DISPLAY_FLAG='0'
AND d.del_tag<>'9'
AND m.STATE<>'4'
AND m.affiliation_tag='1'
) tt,(select count(industryname) as total,ii.industryname as t1_name
from emk_business_domain d,emk_business_member m,
EMK_MEMCO_MEMBERINFO mm,
EMK_BUSINESS_INDUSTRY i,industry ii
WHERE d.busdomain_id=m.busdomain_id
AND mm.memberid=m.memberid
AND i.busdomain_id=d.busdomain_id
AND ii.industryid=i.fir_industry
AND d.DISPLAY_FLAG='0'
AND d.del_tag<>'9'
AND m.STATE<>'4'
AND m.affiliation_tag='1'
group by industryname
) t1
where tt.industryname=t1.t1_name
GROUP BY industryname,domaintype,total