-- An example for Entrance, http://dbentrance.com/

-- This script plots the Case-Shiller housing price index.
-- Information about the Case-Shiller index is on the Standard and Poor's
-- web site:  http://www.standardandpoors.com/ 

USE test;
PLOT LINECHART
    AXISLABELS,
    LIGHT SKYBLUE  LINE,
     RED  THICK   LINE,
     YELLOW    LINE,
    LIGHT RED    LINE,
    LIGHT TANGOORANGE    LINE,
    DARK ALUMINUM    LINE,
      BLUE  THICK  LINE,
    DARK SCARLETRED    LINE,
    DARK CHAMELEON    LINE,
    DARK CHOCOLATE    LINE,
    BUTTER    LINE,
      GREEN THICK LINE,
    CHOCOLATE    LINE,
    CHAMELEON    LINE,
    SKYBLUE    LINE,
    PLUM    LINE,
    SCARLETRED    LINE,
    ALUMINUM    LINE,
    CHARCOAL    LINE,
    LIGHT SKYBLUE     LINE,
    LIGHT SKYBLUE    LINE,
    LIGHT SKYBLUE    LINE

  WITH
    FONT "sanserif" plain 13
    TITLE CENTER "Home Prices"
    TITLE CENTER "S&P/Case-Shiller Home Price Indices"
    GRIDLINES
    FRAME  100 50  750 450
    LEGEND AT 825 50
    -- bar settings
    BARWIDTH 0.85
    BAROVERLAP 0
    NO OUTLINE
    BARSEPARATION 5
SELECT
    `Date`, `AZ_Phoenix`, `CA_Los_Angeles`, `CA_San_Diego`, `CA_San_Francisco`, `CO_Denver`, `DC_Washington`, `FL_Miami`, `FL_Tampa`, `GA_Atlanta`, `IL_Chicago`, `MA_Boston`, `MI_Detroit`, `MN_Minneapolis`, `NC_Charlotte`, `NV_Las_Vegas`, `NY_New_York`, `OH_Cleveland`, `OR_Portland`, `TX_Dallas`, `WA_Seattle`, `Composite_10`, `Composite_20`
  FROM home_prices
  
  ;