如何按ID和月份分组？

SELECT ID, MONTH(date) AS month
FROM table
GROUP BY ID, MONTH(date)

data = [
    {"ID": 1, "date": "2022-01-01"},
    {"ID": 1, "date": "2022-02-15"},
    {"ID": 2, "date": "2022-01-10"},
    {"ID": 2, "date": "2022-02-20"},
]

groups = {}
for item in data:
    ID = item["ID"]
    month = item["date"][5:7]  # 提取日期中的月份信息
    key = (ID, month)
    if key not in groups:
        groups[key] = []
    groups[key].append(item)

for key, items in groups.items():
    ID, month = key
    print("ID:", ID)
    print("Month:", month)
    print("Items:", items)
    print()