##############################################################################
# Python From Scratch
# Autor: Nilo Ney Coutinho Menezes
# Editora Novatec (c) 2010-2024
# Site: https://pythonfromscratch.com
#
# File: listing\chapter 11\11.1493 - No Title.py
# Description: No Title
##############################################################################

import sqlite3

print("Region States Population  Minimum    Maximum      Average    Total (sum)")
print ("====== ======= ========= ========== ========== ============")
with sqlite3.connect("brazil.db") as connection:
    for region in connection.execute("""
        select region, count(*), min(population),
               max(population), avg(population), sum(population)
        from states
        group by region"""):
        print("{0:6} {1:7} {2:18,} {3:10,} {4:10,.0f} {5:13,}".format(*region))
    print("\nBrazil: {0:6} {1:18,} {2:10,} {3:10,.0f} {4:13,}".format(
        *connection.execute("""
            select count(*), min(population), max(population),
                   avg(population), sum(population) from states""").fetchone()))