查询过程中用到的聚合函数
from sqlalchemy import func
func.count:统计行的数量
func.avg:求平均值
func.max:求最大值
func.min:求最小值
func.sum:求和
实例:
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, Float
from sqlalchemy.orm import sessionmaker
from sqlalchemy import func
import random
# localhost
HOSTNAME = '127.0.0.1'
DATABASE = 'student'
PORT