YEAR BY YEAR GROWTH OF SALES
((Latest Year - Previous Year) / Previous Year) * 100
CALCULATE MONTHLY SALES REPORT IN MYSQL
select year(order_date),month(order_date),sum(sale)
from sales
group by year(order_date),month(order_date)
order by year(order_date),month(order_date);
+------------------+-------------------+-----------+
| year(order_date) | month(order_date) | sum(sale) |
+------------------+-------------------+-----------+
| 2020 | 1 | 408 |
| 2020 | 2 | 320 |
| 2020 | 3 | 540 |
| ... | ... | ... |
+------------------+-------------------+-----------+
select date_format(order_date,'%M'),sum(sale)
from sales
group by year(order_date),month(order_date)
order by year(order_date),month(order_date);
+------------------------------+-----------+
| date_format(order_date,'%M') | sum(sale) |
+------------------------------+-----------+
| January | 408 |
| Febuary | 320 |
| March | 540 |
| ... | ... |
+------------------------------+-----------+
CALCULATE AVERAGE SALES PER DAY IN MYSQL
select avg(sale) from sales;
+-----------+
| avg(sale) |
+-----------+
| 22.0000 |
+-----------+
select product, avg(sale) from sales group by product;
+---------+-----------+
| product | avg(sale) |
+---------+-----------+
| A | 23.3333 |
| B | 20.0000 |
+---------+-----------+
CALCULATE AVERAGE SALE PER DAY FOR EACH DAY OF THE WEEK
SELECT DAYNAME(order_date), AVG(sale)
-> FROM sales
-> GROUP BY DAYNAME(order_date);
+---------------------+-----------+
| DAYNAME(order_date) | AVG(sale) |
+---------------------+-----------+
| Friday | 15.0000 |
| Saturday | 30.0000 |
| Sunday | 20.0000 |
| Thursday | 25.0000 |
| Wednesday | 20.0000 |
+---------------------+-----------+