mysql - 带有 SUM 条件的 SELECT

Question

我正在尝试执行一个查询，选择所有用户，其中他们的交易的SUM 大于25。我有这个查询:

SELECT users.uid, SUM( transactions.credits_earned ) AS total
FROM users, transactions
WHERE users.uid = transactions.uid AND ????
GROUP BY users.uid

我尝试在条件中直接使用别名 total 和 SUM 本身，但显然它不起作用(并且有道理)。您知道如何保持查询简单吗？

谢谢，迪奥戈

Answer 1

SELECT users.uid, SUM( transactions.credits_earned ) AS total
FROM users INNER JOIN transactions
ON users.uid = transactions.uid 
GROUP BY users.uid
HAVING SUM(transactions.credits_earned) > 25