Question: 1 . Looking at sheet 2 , how may sales orders did Arkansas ( AR ) customers have? 2 . Looking at sheet 2 ,

1. Looking at sheet 2, how may sales orders did Arkansas (AR) customers have?
2. Looking at sheet 2, what was the grand total quantity sold (across all states and all products)
3. Add state to your results in Sheet 1(examining null values). Which state has the highest number of customers who haven't placed orders? MO
4. Remove the filter from Sheet 1 so that you are not only seeing null values. How many orders have Beverage Distributors placed?
5. Looking at Sheet 2, how many Imperial IPAs were ordered by customers in Kansas (KS)?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!