有没有办法用SQL编写下面的SQLAlchemy语句:
SELECT AVG(a1) FROM (SELECT sum(irterm.n) AS a1 FROM irterm GROUP BY irterm.item_id);
谢谢
发布于 2010-02-16 23:14:28
sums = session.query(func.sum(Irterm.n).label('a1')).group_by(Irterm.item_id).subquery()
average = session.query(func.avg(sums.c.a1)).scalar()
https://stackoverflow.com/questions/2273127
复制相似问题