company price quantity Microsoft 100 10 Google 99 5 Google 99 20 Google 101 15
select price, sum(quantity) as num from shares where company='Google' group by price;
SQLAlchemy写法
你实际上需要label()方法。
result = dbsession.query(Shares.price, \ func.sum(Shares.quantity).label("Total sold")) \ .filter(Shares.company== 'Google') \ .group_by(Shares.price).all()