You're a data analyst at a Zono retail company. Your team has a dataset with sales transactions; you're tasked with analyzing it using MySQL.

Your dataset includes the following tables:

Sales Table: SaleID (unique identifier), ProductID (links to Products table), CustomerID (links to Customers table), SaleDate  Quantity, TotalAmount.

Products Table: ProductID (unique identifier), ProductName, Category  Price 

Customers Table: CustomerID (unique identifier), FirstName, LastName, Email, Country.

Learning Objectives

1. Which product performs best (i.e., has the highest total sales)?

2. Which customer made the most purchases?

3. What is the average sales value by country?

4. How has sales performance trended over time?