在while循环中组合两个查询，包括group by

import mysql.connector

# 建立数据库连接
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

# 创建游标对象
cursor = mydb.cursor()

# 定义查询语句1
query1 = "SELECT column1, SUM(column2) FROM table1 GROUP BY column1"

# 定义查询语句2
query2 = "SELECT column3, AVG(column4) FROM table2 GROUP BY column3"

# 执行查询语句1
cursor.execute(query1)

# 获取查询结果1
result1 = cursor.fetchall()

# 执行查询语句2
cursor.execute(query2)

# 获取查询结果2
result2 = cursor.fetchall()

# 关闭游标和数据库连接
cursor.close()
mydb.close()

# 在while循环中组合两个查询结果
while result1 and result2:
    # 组合查询结果
    combined_result = result1 + result2
    
    # 输出组合结果
    for row in combined_result:
        print(row)
    
    # 更新查询结果
    result1 = cursor.fetchall()
    result2 = cursor.fetchall()