如何在SQLAlchemy中对不同的过滤器进行计数

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

engine = create_engine('数据库连接字符串')
Session = sessionmaker(bind=engine)
session = Session()

from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String

Base = declarative_base()

class MyModel(Base):
    __tablename__ = 'my_table'
    
    id = Column(Integer, primary_key=True)
    name = Column(String)
    # 其他列定义...

filter1 = MyModel.name == 'abc'
filter2 = MyModel.name.like('%def%')
filter3 = MyModel.id > 100

count1 = session.query(func.count()).filter(filter1).scalar()
count2 = session.query(func.count()).filter(filter2).scalar()
count3 = session.query(func.count()).filter(filter3).scalar()

print(count1)
print(count2)
print(count3)