sql根据不同条件查询同一列在同一表中显示？

select date, (case result when '有' then 1 else 0 end)[有], (case result when '无' then 1 else 0 end)[无] from table1