I’ve been asked to provide reports and I can’t find the sort of reports in provided lists, nor can I easily see reports in the forums.
Examples of the reports:
Top 10 customers by for product x (Select top 10 firstname, lastname, address, from customers inner join sales where sales.product = "wine type" and date between 1/1 and 31/12 sort by sales. desc).
Top 10 customers by case or bottle or type for a year
top #x customers by location
customers who make most purchases (eg, how many buy a single bottle vs a case).
We’re really trying to understand our data and our customers.