对于每个AD组，获取表中的成员和操作系统

CREATE TABLE UserADInfo (
    UserID INT PRIMARY KEY,
    UserName VARCHAR(100),
    ADGroup VARCHAR(100),
    OperatingSystem VARCHAR(50)
);

SELECT ADGroup, UserName, OperatingSystem
FROM UserADInfo
ORDER BY ADGroup;

from sqlalchemy import create_engine, Table, MetaData, select

# 创建数据库连接
engine = create_engine('sqlite:///example.db')
metadata = MetaData(bind=engine)

# 定义表结构
user_ad_info = Table('UserADInfo', metadata, autoload_with=engine)

# 执行查询
stmt = select([user_ad_info.c.ADGroup, user_ad_info.c.UserName, user_ad_info.c.OperatingSystem]).order_by(user_ad_info.c.ADGroup)
with engine.connect() as conn:
    result = conn.execute(stmt)
    for row in result:
        print(f"AD Group: {row['ADGroup']}, User: {row['UserName']}, OS: {row['OperatingSystem']}")