mysql分组统计订单

SELECT
    *,SUM(a.order_price) as totalPrice,COUNT(a.id) as orderNum
FROM
    consult  b
LEFT JOIN  orderinfo a on a.consult_id = b.id
WHERE 
a.create_time >='2022-02-28' AND 
a.create_time <='2022-02-29'
GROUP BY b.id
ORDER BY totalPrice ASC