如何对已分组的外键进行过滤？

SELECT p.product_name, COUNT(o.order_id) AS order_count
FROM products p
JOIN orders o ON p.product_id = o.product_id
GROUP BY p.product_name
HAVING COUNT(o.order_id) > 10;

from sqlalchemy import create_engine, Table, Column, Integer, String, MetaData, ForeignKey
from sqlalchemy.orm import sessionmaker, relationship

engine = create_engine('sqlite:///example.db')
metadata = MetaData()

products = Table('products', metadata,
                 Column('product_id', Integer, primary_key=True),
                 Column('product_name', String))

orders = Table('orders', metadata,
               Column('order_id', Integer, primary_key=True),
               Column('product_id', None, ForeignKey('products.product_id')))

metadata.create_all(engine)
Session = sessionmaker(bind=engine)
session = Session()

# 执行分组和过滤
result = session.query(products.c.product_name, func.count(orders.c.order_id).label('order_count')) \
               .join(orders, products.c.product_id == orders.c.product_id) \
               .group_by(products.c.product_name) \
               .having(func.count(orders.c.order_id) > 10).all()

for row in result:
    print(row.product_name, row.order_count)