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()