-- drop table if exists t;
create table t (
  	i int
);

insert into t 
  select * from ref1;

plot
  axislabels, swath, rgb(255,64,64) swath, rgb(255,96,96) swath, rgb(255,128,128) swath, rgb(255,160,160) swath,  rgb(255,192,192) swath,
      rgb(255,224,224) swath
  with
    frame 40 20 400 200
    page 0 0 800 250
    title x "Number of Periods"
    format y decimal "#x"
    scale y 1 6 1
    solid horizontal light gray gridlines 
    no sides
    no axisline x
    no axisline y
    foreground gray
    collar
    legend at 550 200
    title "Return on Investment"
select i,  
     pow(1.06, i) as "", pow(1.05, i) as "5% - 6%", 
       pow(1.04, i) as "4% - 5%", pow(1.03, i) as "3% - 4%", pow(1.02, i) as "2% - 3%", 
       pow(1.01, i) as "1% - 2%", 1 as "0 - 1%"
  from t
  where i <=31;

plot
  axislabels, swath, rgb(255,64,64) swath, rgb(255,96,96) swath, rgb(255,128,128) swath, rgb(255,160,160) swath,  rgb(255,192,192) swath,
      rgb(255,224,224) swath
  with
    frame 60 20 400 200
    page 0 0 800 250
    title x "Number of Periods"
    format y decimal "#.##x"
    scale y 1 2 0.25
    solid horizontal light gray gridlines 
    no sides
    no axisline x
    no axisline y
    foreground gray
    legend at 550 200
    title "Return on Investment"
select i,  
     pow(1.06, i) as '', pow(1.05, i) as "5% - 6%", 
       pow(1.04, i) as "4% - 5%", pow(1.03, i) as "3% - 4%", pow(1.02, i) as "2% - 3%", 
       pow(1.02, i) as "1% - 2%", 1 as "0 - 1%"
  from t
  where i <=31;