def METHOD_NAME(con):
    table = con.table("basic_table")
    result = table.aggregate(max=table["id"].max()).compile()
    expected = table.compile().agg(F.max("id").alias("max"))
    tm.assert_frame_equal(result.toPandas(), expected.toPandas())