'sqlalchemy: get max/min/avg values from a table

I have this query:

mps =   (
            session.query(mps)  .filter_by(idc = int(c.idc))
                                .filter_by(idmp = int(m.idmp))
                                .group_by(func.day(mps.tschecked))
        ).all()

My problem is, that I don't know how to extract (with sqlalchemy) the max/min/avg value from a table...

I find this: Database-Independent MAX() Function in SQLAlchemy

But I don't know where to use this func.max/min/avg...

Can someone tell me how to do this? Can you give me an example?

python sqlalchemy

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'sqlalchemy: get max/min/avg values from a table

Sources

Related Questions