问题:我想看每家店在某一段期间内的营业额占比,怎么求?
思路:第一步求出每家店的营业额。第二步求出总营业额。第三步用每家店的营业额除以总营业额得出
select t1.shop_id, t1.shop_name, t1.shop_money, round(t1.shop_money/t2.total_money*100, 2) as shop_money_per
from(
select sd.shop_id, s.shop_name, sum(sd.
问题:我想看每家店在某一段期间内的营业额占比,怎么求?
思路:第一步求出每家店的营业额。第二步求出总营业额。第三步用每家店的营业额除以总营业额得出
select t1.shop_id, t1.shop_name, t1.shop_money, round(t1.shop_money/t2.total_money*100, 2) as shop_money_per
from(
select sd.shop_id, s.shop_name, sum(sd.