今日学习笔记及课后练习


-- 17、求出最畅销的十个商品所属品牌中所有商品的销售额

-- a.求出最畅销的十个商品的品牌
-- b.求品牌下的商品的销售额

select t.typeid 品牌,goodsinfo.goodsid 商品,sum(amount*goodsprice) 销售额
        from orderdetail
        left join goodsinfo on orderdetail.goodsid=goodsinfo.goodsid
        right join (select typeid
                from orderdetail o left join goodsinfo g on o.goodsid=g.goodsid
                group by o.goodsid
                order by sum(amount) desc limit 10) as t on goodsinfo.typeid = t.typeid
group by goodsinfo.goodsid
order by t.typeid;