WITH test AS(
SELECT 100 a1,10 b1,100 a2,10 b2,100 a3,10 b3 FROM dual)
SELECT (CASE WHEN A1 >= B1 * 10 AND A1 <= B1 * 20 THEN 1 ELSE 0 END) +
(CASE WHEN A2 >= B2 * 10 AND A2 <= B2 * 20 THEN 1 ELSE 0 END) +
(CASE WHEN A3 >= B3 * 10 AND A3 <= B3 * 20 THEN 1 ELSE 0 END)
FROM TEST
SELECT 100 a1,10 b1,100 a2,10 b2,100 a3,10 b3 FROM dual)
SELECT (CASE WHEN A1 >= B1 * 10 AND A1 <= B1 * 20 THEN 1 ELSE 0 END) +
(CASE WHEN A2 >= B2 * 10 AND A2 <= B2 * 20 THEN 1 ELSE 0 END) +
(CASE WHEN A3 >= B3 * 10 AND A3 <= B3 * 20 THEN 1 ELSE 0 END)
FROM TEST
A1 >= B1 * 0.5 AND A1 <= B1 * 1.5就行