oracle一张表，不同的where条件count出来的结果，并列创建在一个视图里，sql怎么写？

create view vw_new as

select sum(case when fnumber = 100013 then 1 else 0 end) count_1,
sum(case when fnumber = 100012 then 1 else 0 end) count_2,
sum(case when fnumber = 100011 then 1 else 0 end) count_3 From table_c a本回答被提问者采纳