drop table if exists testscores;
create table testscores (
  id int,
  score	int
);

insert into testscores (id,score)
values
  (1, 4),
  (2, 6),
  (3, 8),
  (4, 9),
  (5, 5),
  (6, 5),
  (7,4),
  (8,6),
  (9,7),
  (10,8),
  (11,9),
  (12,4),
  (13,1),
  (14,8),
  (15,6),
  (16,9),
  (17,7),
  (18,9),
  (19,2),
  (20,7),
  (21,10),
  (22,0),
  (23,7),
  (24,10),
  (25,4)
;

plot histogram
    xlabels, pink bars, datalabels
  with
     title "Test Scores"
     title "Math Test, Administered 4-25-07"
     title "Epsilon Elementary School" 
     title ""
     title y "Count"
     title x "Scores"
select score, count(*), count(*)
  from testscores
  group by score
  order by score;