SQLite Forum

Showing data for 5 Years Interval of products.
Login
Something like this:

```
create table sales(product,year,sales);

insert into sales values('A','2000',0);   -- excluded because zero
insert into sales values('A','2001',10);
insert into sales values('A','2002',20);
insert into sales values('A','2003',20);  -- excluded by year range

insert into sales values('B','2000',5);
insert into sales values('B','2001',10);
insert into sales values('B','2002',0);   -- excluded because zero
insert into sales values('B','2003',100); -- excluded by year range

select product,min(sales),avg(sales),max(sales) from sales
  where year between '2000' and '2002'
    and sales > 0
  group by product;
```

Adjust `WHERE` according to the years you need.