UPDATE t_customer
SET risk_level = (
CASE
WHEN risk_level BETWEEN 1
AND 5 THEN
2
WHEN risk_level BETWEEN 6
AND 8 THEN
1
ELSE
0
END
);
UPDATE t_customer
SET risk_level = (
CASE
WHEN risk_level BETWEEN 1
AND 5 THEN
2
WHEN risk_level BETWEEN 6
AND 8 THEN
1
ELSE
0
END
);