import sqlite3

connection = sqlite3.connect('example.sqlite')

c = connection.cursor()

countries = [('Denmark', 5748769, 42931, 'Copenhagen'),
             ('Germany', 82800000, 357168, 'Berlin'),
             ('USA', 325719178, 9833520, 'Washington, D.C.'), 
             ('Iceland', 334252, 102775, 'Reykjavik')]

cities = [('Copenhagen', 775033, 800),
          ('Aarhus', 273077, 750),
          ('Berlin', 3711930, 1237),
          ('Munich', 1464301, 1158),
          ('Reykjavik', 126100, 874),
          ('Washington, D.C.', 693972, 1790),
          ('New Orleans', 343829, 1718),
          ('San Francisco', 884363, 1776)]

c.execute('''CREATE TABLE country (name, population, area, capital)''')

c.executemany('INSERT INTO country VALUES (?,?,?,?)', countries)

c.execute('''CREATE TABLE city (name, population, established)''')

c.executemany('INSERT INTO city VALUES (?,?,?)', cities)

connection.commit()

for row in c.execute('SELECT * FROM city'):
    print(row)

for row in c.execute(
    '''SELECT country.name, city.name, city.established FROM city, country
       WHERE city.name=country.capital AND city.population < 700000'''):
    print(row)

connection.close