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