PeterCat12

# Database
# https://docs.djangoproject.com/en/1.10/ref/settings/#databases
LOCAL_DB_IP = os.environ.get('DB_1_PORT_5432_TCP_ADDR', 'db')
DATABASE_USER = os.environ.get('DATABASE_USER', 'postgres')
DATABASE_PASSWORD = os.environ.get('DATABASE_PASSWORD', 'postgres')
DATABASE_NAME = os.environ.get('DATABASE_NAME', 'postgres')

DATABASES = {
    'default': dj_database_url.config(
        # default='postgis://postgres:postgres@{0}/postgres'.format(LOCAL_DB_IP)

PeterCat12

version: '2'
services:
 db:
   image: postgres
 web:
   build: .
   hostname: web
   command: python manage.py runserver 0.0.0.0:8000
   volumes:
     - .:/code

PeterCat12

SELECT
                MONTH(t1.recording_date) as "month",
                YEAR(t1.recording_date) as "year",
                ROUND(AVG(NULLIF(t1.sale_amount,0)), 0) as "Average_sale_amount",
                ROUND(AVG(t1.sale_amount) / AVG(t2.living_square_feet), 0) as "average_price_sqft",
                COUNT(id) as "closed sales",
                COALESCE(sum(CASE WHEN t2.year_built = 2010 THEN 1 ELSE 0 END), 0) as "number_of_homes_built"
                FROM bulk_deed_layout t1
                join tax_deed_data as t2
				on (t1.batch_id = t2.batch_id and t1.batch_seq = t2.batch_seq)

PeterCat12

SELECT
                MONTH(t1.recording_date) as "month",
                YEAR(t1.recording_date) as "year",
                ROUND(AVG(NULLIF(t1.sale_amount,0)), 0) as "Average_sale_amount",
                ROUND(AVG(t1.sale_amount) / AVG(t2.living_square_feet), 0) as "average_price_sqft",
                COUNT(id) as "closed sales",
                COALESCE(sum(CASE WHEN t2.year_built = 2010 THEN 1 ELSE 0 END), 0) as "number_of_homes_built"
                FROM bulk_deed_layout t1
                join tax_deed_data as t2
				on (t1.batch_id = t2.batch_id and t1.batch_seq = t2.batch_seq)