SQLAlchemy select from subquery和order by子查询字段

from sqlalchemy import create_engine, select, func
from sqlalchemy.orm import sessionmaker

# 创建数据库引擎和会话
engine = create_engine('数据库连接字符串')
Session = sessionmaker(bind=engine)
session = Session()

# 创建子查询
subquery = session.query(Table1.column1, func.count(Table2.column2).label('count')).\
    join(Table2, Table1.id == Table2.table1_id).\
    group_by(Table1.column1).subquery()

# 执行主查询
query = session.query(subquery.c.column1, subquery.c.count).\
    order_by(subquery.c.count.desc())

# 获取查询结果
results = query.all()

# 打印查询结果
for result in results:
    print(result.column1, result.count)