#前5个字段 with t1 as( select p.product_id, sum(quantity)*unit_price as total_sales, unit_price, sum(quantity) as total_quantity, round(sum(quantity)*unit_price/12,2) as avg_monthly_sales from products p join orders o on p.product_id=o.product_id group by p.product_id ), #月最高销量 t2 as( select product_id,...
