Skip to content Skip to sidebar Skip to footer

Sqlalchemy Subquery - Average Of Sums

is there any way how to write the following SQL statement in SQLAlchemy ORM: SELECT AVG(a1) FROM (SELECT sum(irterm.n) AS a1 FROM irterm GROUP BY irterm.item_id); Thank you

Solution 1:

sums = session.query(func.sum(Irterm.n).label('a1')).group_by(Irterm.item_id).subquery()
average = session.query(func.avg(sums.c.a1)).scalar()

Post a Comment for "Sqlalchemy Subquery - Average Of Sums"