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.