python import sqlite3 conn = sqlite3.connect('population.db') cursor = conn.cursor() cursor.execute("SELECT city, SUM(population) FROM population_table GROUP BY city") results = cursor.fetchall() for row in results: print(row[0], row[1]) cursor.close() conn.close() python import sqlite3 conn = sqlite3.connect('population.db') cursor = conn.cursor() cursor.execute("SELECT city, SUM(population) FROM population_table GROUP BY city HAVING SUM(population) > 10000000") results = cursor.fetchall() for row in results: print(row[0], row[1]) cursor.close() conn.close()


上一篇:
下一篇:
切换中文