SELECT UID as 用户 ,COUNT(ORDER_SN)as 订单总数,SUM(TOTAL)as 合计总金额 FROM 订单表 group by uid