sqlj.py

#SQLite functions

import sqlite3

with sqlite3.connect("new.db") as connection:
    c = connection.cursor()
    
    # create a dictionary of sql queries
    sql = {'average': "SELECT avg(population) FROM population",
           'maximum': "SELECT max(population) FROM population",
           'minimum': "SELECT min(population) FROM population",
           'sum:': "SELECT sum(population) FROM population",
           'count': "SELECT count(city) FROM population"}
    
    # run each sql query item in the dictionary
    for keys, values in sql.iteritems():
        
        #run SQL
        c.execute(values)
        
        #retrieve one record
        result = c.fetchone()
        
        #output
        print keys + ":", result[0]