SQLite Forum

Showing data for 5 Years Interval of products.
Login
Write an SQL statement to provide the data you need.

Data you have not provided which would be needed to make suggestions include:  
(a) the table that contains the source data (as in the create table statement)  
(b) the definition of what constitutes a "5 year interval" such as when does it begin  
(c) do you know how to write a program to write the report once the data is provided  

This is the absolute minimum data required if you want any answer other than that you need to write SQL queries to extract the data that you want so that you can write a program to run those queries and output the resulting report.