您根本无法使静态SQL语句返回可变数量的列。每次不同地区的数量更改时，您都需要构建这样的语句。为此，您首先执行
SELECt DISTINCT District FROM district_details;
这将为您提供有详细信息的地区列表。然后，您构建一个遍历先前结果的SQL语句（伪代码）
statement = "SELECt name "For each row returned in d = SELECT DISTINCT District FROM district_details statement = statement & ", SUM(IF(District=""" & d.District & """,1 ,0)) AS """ & d.District & """"statement = statement & " FROM district_details GROUP BY name;"
并执行该查询。然后，您需要在代码中处理可变数量的列
