Re: [sqlalchemy] Functions on results of subquery question

2009-11-28 Thread Mike Conley
On Fri, Nov 27, 2009 at 10:55 AM, Oliver Beattie wrote: > Hey there, > > I'm probably missing something here, but no matter what I try, I can't > seem to find a way to translate this query into SQLAlchemy code: > >SELECT AVG(sub.average) >FROM ( >SELECT AVG(feedback.overall_rating)

[sqlalchemy] Functions on results of subquery question

2009-11-27 Thread Oliver Beattie
Hey there, I'm probably missing something here, but no matter what I try, I can't seem to find a way to translate this query into SQLAlchemy code: SELECT AVG(sub.average) FROM ( SELECT AVG(feedback.overall_rating) AS average FROM feedback INNER JOIN listings ON fee