我如何在SQL中查询三个指标a, b, c，并验证它们满足(a + b)/2 = c?

Question

现在我想查询数据库中的三个指标a、b和c，验证公式(a + b)/2 = c是否成立。我该怎么办?我现在只能查询a b和c

select
a,
b,
c
from
table_test
where
type = 1
and
origin not in (10, 20)

Answer 1

在WHERE子句中添加断言:

SELECT a, b, c, IF((a + b) / 2 = c, 'True', 'False') AS result
FROM table_test
WHERE type = 1 AND origin NOT IN (10, 20) AND
(a + b) / 2 = c;   -- added condition here