select  sum(quantity) as items_ordered from OrderItems where prod_id='BR01';
select sum(quantity) as items_odered from OrderItems group by prod_id having prod_id='BR01';