select coalesce(count(multiIf(t.is_in_stock='是',1,null)),0) as value_1, coalesce(count(multiIf(t.is_in_stock='是',null,1)),0) as value_0, coalesce(round(count(1),2),0) as total…