题解 | #某宝店铺折扣率#
某宝店铺折扣率
http://www.nowcoder.com/practice/3a56f160308441f5a79d8ac8d953e5e7
select round(100sum(s.sales_price)/sum(p.tag_prices.sales_num),2) as discount_rate from sales_tb s left join product_tb p using(item_id)
某宝店铺折扣率
http://www.nowcoder.com/practice/3a56f160308441f5a79d8ac8d953e5e7
select round(100sum(s.sales_price)/sum(p.tag_prices.sales_num),2) as discount_rate from sales_tb s left join product_tb p using(item_id)
相关推荐