SQLsummary/报表/本期奖金区间与人数分析表.sql

SET @PERIOD_MIN = 141;
SET @PERIOD_MAX = 159;

	
	SELECT
		B.`结算期数` AS 期数,
		B.`会员编号`,
		B.`会员姓名`,
		B.`总奖金`
	FROM
		zr_bonus_vw B
		WHERE B.`结算期数`>= @PERIOD_MIN AND B.`结算期数` <= @PERIOD_MAX AND B.`总奖金` >= 1