mysql
CASE WHEN 判断条件 THEN 字段 END
select COUNT(activity_people_id) as applyCount, #活动报名人数
<!--活动签到人数-->
COUNT( CASE WHEN sign_in_time is not null THEN activity_people_id END ) AS signCount,
<!--活动签退人数-->
COUNT( CASE WHEN sign_out_time is not null THEN activity_people_id END ) AS signOutCount
from activity_people where status=0 and activity_id = #{activityId}