一种使用left join的写法

select
  prod_name,
  sum(quantity) quant_sold
from
  Products
  left join OrderItems using(prod_id)
group by
  prod_name;