-- A sample for the Entrance blog:  http://dbentrance.com/blog/

plot datetimedirchart
    x, length, light red direction, datalabels above, length, light blue direction
  WITH    
    title "Wind on Ben Lomond Mountain"
    scale  x  '2009-10-26 12:00' '2009-10-29 12:00'  24 hours
    format x  "%m-%d %H:00" 
    scale  y  0 40 10 
    title y "wind speed (mph)"
    labelangle 0
    page threefourths
    no clip
    gridlines
    no sides
    legend bottom
select
  dt, peak_wind_speed, peak_wind_dir as "Peak Wind", 
     if(peak_wind_speed =  
         (select max(peak_wind_speed) 
             from raws_bl), peak_wind_speed, ''),
        wind_speed, wind_dir as "Wind"
  from raws_bl
  ;