笔试题（数据库）

SQL中的运算

情景：查商品表联销量表，按type分类统计每个type商品的利润((price-cost) * num 求和)

SELECT a.type,sum((a.price-a.cost)*b.num) as profit FROM goods a LEFT JOIN sale b ON a.goods_id=b.goods_id GROUP BY a.type ORDER BY profit DESC;