-- hello pie world

-- drop table if exists pietemp; 

create temporary table pietemp (
  name varchar(255),
  val    int,
  color  varchar(255)
);

insert into pietemp values
   ('one', 30,   'very light red'),
   ('two', 10,   'light red'),
   ('three', 5,  'red'),
   ('four', 40,  'very light blue'),
   ('five', 10,  'light blue'),
   ('six', 20,   'blue'),
   ('seven', 80, 'very light yellow'),
   ('eight', 10, 'light yellow'),
   ('nine', 3,   'yellow'),
   ('ten', 100,  'very light green'),
   ('eleven', 10,'light green'),
   ('twelve', 1,  'green')
;

plot pie
  pielabel, pievalue, color override
  with
    title "Hello Pie World"
select * from pietemp;