北栀(提问者)select count((CASE WHEN d.c_status=\'已签约\' THEN d.c_no ELSE 0 END)) [已租商铺数量],count((CASE WHEN d.c_status=\'待招商\' THEN d.c_no ELSE 0 END)) [空置商铺数量] ,
sum(cast(d.c_no as bigint)) [可租商铺数量]
from 视图 a
INNER JOIN tbm_counter d on a.c_counter_nos=d.c_no where d.c_status in (\'已签约\',\'待招商\')
group by d.c_status,d.c_no
Z4u3z1 回复 北栀(提问者)select SUM((CASE WHEN d.c_status=\'已签约\' THEN 1 ELSE 0 END)) [已租商铺数量],SUM((CASE WHEN d.c_status=\'待招商\' THEN 1 ELSE 0 END)) [空置商铺数量] , COUNT(d.c_status) [可租商铺数量] from 视图 a INNER JOIN tbm_counter d on a.c_counter_nos=d.c_no where d.c_status in (\'已签约\',\'待招商\') group by d.c_status,d.c_no