SET @k = 0; -- 定义临时变量
SELECT
	*,
CASE   -- 零时编排序号
	WHEN id MOD 2 = 0 
	AND id MOD 4 = 0 THEN
	's4' 
	WHEN ( id + 3 ) MOD 2 = 0 
	AND ( id + 3 ) MOD 4 != 0 THEN
	's3' 
	WHEN id MOD 2 = 0 
	AND id MOD 4 != 0 THEN
	's2' 
	WHEN ( id + 3 ) MOD 2 = 0 
	AND ( id + 3 ) MOD 4 = 0 THEN
	's1' ELSE '0' 
	END 'd' -- case 判断属于s1-s4
	
FROM
	(
SELECT
*,
avg( t ) avg,
	( @K := @K + 1 ) id -- 零时编排序号
	
FROM
	(
	SELECT
		COLLECTION_TIME,
		CONCAT( a2.COLLECTION_TIME, '_', a2.UNIT_NAME ) AS x,
		UNIT_NAME,
		RESOURCE_NAME,
		fMPA_CuGain AS t 
	FROM
		parameter_pid106a_02 a2
		INNER JOIN ( SELECT UNIT_NAME AS dmc FROM parameter_pid106a_02 GROUP BY UNIT_NAME ORDER BY COLLECTION_TIME DESC ) a1 ON a2.UNIT_NAME = a1.dmc 
	) a3 
GROUP BY
	A3.UNIT_NAME 
ORDER BY
	COLLECTION_TIME DESC 
) a4