题解 | #某宝店铺折扣率#
某宝店铺折扣率
https://www.nowcoder.com/practice/3a56f160308441f5a79d8ac8d953e5e7
select
round((sum(sales_price) / sum(tag_amt)) * 100, 2) as 'discount_rate(%'
from
(
select
s.item_id,
sales_num * p.tag_price as tag_amt,
s.sales_price
from
sales_tb s
left join product_tb p on s.item_id = p.item_id
) t
SQL大厂面试题 文章被收录于专栏
牛客网sql大厂面试题题解~
