SQLite Forum

Showing data for 5 Years Interval of products.
Login
I have a product, year, and sales columns where different products are shown for each year with their corresponding year and sales from 2000 to 2018. 

I have to show avg, min, and max sales of each Product for 5 years interval.

Also, the query should omit the ‘0’ values when calculating the average and minimum value of the product.

How can we achieve it?