SELECT 
SUM( goods_amount ) AS money, 
count( * ) AS num,
count(if(pay_status=1,true,null)) AS success, 
count(if(pay_status=2,true,null)) AS fall 
FROM `tab_order_info` 
WHERE user_id = 11

 

 

posted on 2018-07-25 17:17  小良下山化了个缘  阅读(153)  评论(0编辑  收藏  举报