分析

关键词：sum--汇总和函数

代码

select sum(quantity) as items_ordered
from OrderItems
where prod_id='BR01'