对行进行分组和计数，然后在条件中使用它们

I have an query like:

我有一个查询：

SELECT * FROM account AS a 
LEFT JOIN (SELECT SUM(bill.amount) total, bill.accountId FROM bill GROUP BY bill.accountId) b ON a.id = b.accountId
WHERE a.partner_id = 1 OR a.partner_id = 2
SELECT * FROM