带有子查询，分组依据，计数和求和功能的高级SQL查询到SQLalchemy

这是我对查询的重写：

SELECt t3.*,      x.count,      x.amount FROM TABLE3 t3 JOIN (SELECt t2.cus_id   COUNT(*) AS count,   SUM(t2.amount) AS total         FROM TABLE2 t2        WHERe EXISTS(SELECt NULL FROM TABLE1 t1WHERe t1.own_id = t2.own_id)     GROUP BY t2.cus_id) x ON x.cus_id = t3.id

抱歉，SQLAlchemy部分无法帮助您。