select prod_name,sum(quantity) as quant_sold from Products P
inner join OrderItems OI on P.prod_id = OI.prod_id
group by prod_name;
标签:group,name,..,sum,Products,prod,id
From: https://blog.csdn.net/qq_46034034/article/details/137169112
select prod_name,sum(quantity) as quant_sold from Products P
inner join OrderItems OI on P.prod_id = OI.prod_id
group by prod_name;
标签:group,name,..,sum,Products,prod,id
From: https://blog.csdn.net/qq_46034034/article/details/137169112