[quote]
根据 apply_status 的值 来分类
[/quote]
根据 apply_status 的值 来分类
[/quote]
select s.* , count(case when ob.apply_status = 7 then ob.apply_status end) as reject_count,
count(case when ob.apply_status > 1 and ob.apply_status < 6 then ob.apply_status end) as inprogress_count,
count(case when ob.apply_status > 0 then ob.apply_status end) as total_count
from salesman s left join order_base ob on s.salesman_id = ob.salesman_id
where ob.apply_status > 0
group by s.salesman_id ;