月奖金拨比分析(月金额,月PV).sql 157 B

123456789
  1. SET @MONTHS = '202103';
  2. SELECT
  3. O.`月份`,
  4. SUM(O.`商品金额`) AS 月金额,
  5. SUM(O.`PV合计`) AS 月PV
  6. FROM
  7. zr_order_vw O
  8. WHERE O.`月份` = @MONTHS