text: drop table if exists zll;
  create table zll (i float);
  insert into zll values(0);
  insert into zll values(5);
  insert into zll values(null);
  insert into zll values(-987654321.987654321);
  insert into zll values(987654321.987654321);
  insert into zll values(-987654321.987654321);
  insert into zll values(987654321.987654321);
  insert into zll values(null);
  select sum(i) from zll;
  select avg(i) from zll;
  select sum(distinct i) from zll;
  select avg(distinct i) from zll;
  select sum(distinct i),count(distinct i),avg(distinct i) from zll;
  drop table zll;
  create table zll (i float);
  insert into zll values(987654321.987654321);
  insert into zll values(-987654321.987654321);
  insert into zll values(987654321.987654321);
  insert into zll values(-987654321.987654321);
  insert into zll values(null);
  insert into zll values(null);
  insert into zll values(0);
  insert into zll values(5);
  select sum(i) from zll;
  select avg(i) from zll;
  select sum(distinct i) from zll;
  select avg(distinct i) from zll;
  select sum(distinct i),count(distinct i),avg(distinct i) from zll;
  drop zll;
  