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

知识点:
1、在上题的基础上,增加了条件筛选