如何在python sqlobject中使用Table.select()方法进行以下sql操作？

from sqlobject import SQLObject, StringCol, IntCol

class Person(SQLObject):
    name = StringCol()
    age = IntCol()

# 获取所有Person记录
people = Person.select()

for person in people:
    print(person.name, person.age)

# 获取年龄大于30的Person记录
older_people = Person.select(Person.q.age > 30)

for person in older_people:
    print(person.name, person.age)

# 按年龄降序排列Person记录
sorted_people = Person.select(orderBy=Person.q.age.desc())

for person in sorted_people:
    print(person.name, person.age)

# 按年龄分组并计算每组的平均年龄（注意：SQLObject本身不直接支持GROUP BY的聚合函数，需要手动编写SQL）
# 这里仅展示如何构建查询，实际执行可能需要额外的处理
grouped_query = "SELECT age, AVG(age) FROM Person GROUP BY age"
# 执行原生SQL查询
from sqlobject.sqlbuilder import SQLBuilder
sql, params = SQLBuilder.buildSQL(Person, grouped_query)
results = Person._connection.queryAll(sql, params)
for row in results:
    print(row)

# 假设有另一个表Address与Person通过person_id关联
class Address(SQLObject):
    person = ForeignKey('Person')
    street = StringCol()

# 获取每个Person及其对应的Address
joined_query = Person.select(Person.q.age > 30, join=Address)
for person, address in joined_query:
    print(person.name, person.age, address.street)

# 确保表存在
if not Person.exists():
    Person.createTable()

# 再次尝试查询
people = Person.select()