黑马程序员2023最新Java项目实战《苍穹外卖》，最适合新手的SpringBo

SELECT c.`name`,sum(c.number)

FROM 

(SELECT a.`name`,a.number,b.`status`

FROM order_detail as a LEFT JOIN orders as b ON a.order_id=b.id and b.`status`=5) as c

GROUP BY c.`name`