4,018
社区成员




```
select
b.shipper 快递名称,
a.到付次数,a.现付次数,a.寄付次数
from (select
shipperCode ,
count(1) 使用次数,
sum(case when payment = 0 then 1 else 0 end) 到付次数,
sum(case when payment = 1 then 1 else 0 end) 现付次数,
sum(case when payment = 2 then 1 else 0 end) 寄付次数
from D_order
where userID= '张三'
group by shipperCode
) as a
inner join D_shipper b on a.shipperCode = b.shipperCode
```sql
请参考,如果觉得有帮助,请随意打赏,谢谢