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

select region, count(*), min(population), max(population), avg(population),          sum(population) as tpop
   from states group by region
   order by tpop desc