select sum(quantity) as items_ordered
from OrderItems
where prod_id = 'BR01';
from OrderItems
where prod_id = 'BR01';
「求助大佬帮看看这道算法题吧!」
OrderItems表代表售出的产品,quantity代表售出商品数量,产品项为prod_id。
https://gw-c.nowcoder.com/api/sparta/jump/link?link=https%3A%2F%2Fwww.nowcoder.com%2Fpractice%2Fa225d8a7bc4f496283fe8e21293e841c
全部评论
相关推荐
点赞 评论 收藏
分享