case when xxx then
when yyy then
when zzz then
else 0 end;
----一行数据
case when xxx then else 0 end,
case when yyy then else 0 end,
case when zzz then else 0 end
----多行数据
case when xxx then
when yyy then
when zzz then
else 0 end;
----一行数据
case when xxx then else 0 end,
case when yyy then else 0 end,
case when zzz then else 0 end
----多行数据