Coffee Sales

Coffee Sales Requirements

1. What is the sum of total sales?
   

Ans. The total sales for 2020-2022 is 45134. Excelsa is the most sold coffee type ($12306), while Robusta is the least sold coffee type ($9005).

2. What is the sum of sales by country?
   

Ans. United State has the highest sales of coffee ($35639) and United Kingdom with the lowest coffee sales ($2799).

3. Who are the top 5 customers?
   

Ans. The coffee shop had 1000 customers within the 3 years. Allis Wilmore, Brenn Dundredge, Terri Farra, Nealson Cuttler, Don Flintiff as the top 5 customers.