oracle关于case when和count结合的用法

select count(case

when b.schedule = ‘0’ then

‘男’ else null end),

count(case when b.schedule = ‘1’ then

‘女’else null end)

from wsbs_apply b