36.从 Products 表中检索所有的产品名称以及对应的

select prod_name,sum(quantity) as quant_sold
from Products a,OrderItems b
where a.prod_id = b.prod_id
group by prod_name

select prod_name,avg(quantity) as quant_sold
from Products a,OrderItems b
where a.prod_id = b.prod_id
group by prod_name

select prod_id ,sum(quantity)
from OrderItems group by prod_id

select p.prod_name,sum(o.quantity)
from Products as p,OrderItems as o
group by p.prod_name;