SET @MONTHS = '202103'; SELECT O.`月份`, SUM(O.`商品金额`) AS 月金额, SUM(O.`PV合计`) AS 月PV FROM zr_order_vw O WHERE O.`月份` = @MONTHS