count, min, max = (
            session.query(
                func.count().label("count"),
                func.min(Picture.id).label("min"),
                func.max(Picture.id).label("max"),
            )
            .filter(Picture.android_id == android_id)
            .one()
        )
        data = {"count": count, "min": min, "max": max}			
			
			

				

# 最大值
result = session.query(func.max(Article.price)).first()
print(result)

# 最小值
result = session.query(func.min(Article.price)).first()
print(result)


				
				
			

			
        data = session.query(
            func.min(Picture.id).label("min"), func.max(Picture.id).label("max")
        ).one()	
        
        min, max = session.query(
            func.min(Picture.id).label("min"), func.max(Picture.id).label("max")
        ).one()
        
        data = {"min": min, "max": max}        
			
			

				
# 平均值
result = session.query(func.avg(Article.price)).first()
print(result)
# 求和
result = session.query(func.sum(Article.price)).first()
print(result)