title: sqlalchemy: get max/min/avg values from a table
body: <p>I have this query:</p>
  
  <pre><code>mps =   (
              session.query(mps)  .filter_by(idc = int(c.idc))
                                  .filter_by(idmp = int(m.idmp))
                                  .group_by(func.day(mps.tschecked))
          ).all()
  </code></pre>
  
  <p>My problem is, that I don't know how to extract (with sqlalchemy) the max/min/avg value from a table...</p>
  
  <p>I find this: <a href="https://stackoverflow.com/questions/2358634/database-independent-max-function-in-sqlalchemy">Database-Independent MAX() Function in SQLAlchemy</a></p>
  
  <p>But I don't know where to use this func.max/min/avg...</p>
  
  <p>Can someone tell me how to do this? Can you give me an example?</p>