-- sample for Entrance   http://dbentrance.com/

-- To make something like this you will want to start with
-- Charts | Make a line chart 
USE test;
PLOT LINECHART
    ONLY 3 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
    LEGEND RIGHT
    -- bar settings
    BARWIDTH 0.85
    BAROVERLAP 0
    NO OUTLINE
    BARSEPARATION 5
SELECT
    concat(left(Date,3), ', ', right(`Date`,4)), `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`
 FROM home_prices
  
  ;