請教sql語句高手 壹個視圖 多個計算結果

創建測試表

(id?varchar(2),

prod?varchar(10),

gup?varchar(10),

sdb?varchar(1))

insert?into?test?values('01','AAAA','SKC','Y')

insert?into?test?values('02','AAAA','SKC','N')

insert?into?test?values('03','AAAA','ZPC','Y')

insert?into?test?values('04','BBBB','ZPC','Y')

insert?into?test?values('05','BBBB','ZPC','N')

創建視圖

as

select?prod,gup,count(*)?[sum],sum(case?when?sdb='Y'?then?1?else?0?end)?sdbsum

from?test?group?by?prod,gup

結果