4 Replies Latest reply on Apr 20, 2018 3:19 AM by Jim Dehner

    Exact numbers of orders returned and exact cities we sell to...?

    Zanny Kay

      Hello,

       

      Working on playing with the global superstore data and some practice questions. Need some assistance, would like to know who to find exact number of orders returned in certain month of a certain year and also the sales and profits associated with the returns? I currently have orders and returns connected with an inner join.

       

      Also, how can I show the exact cities we sell to in a certain state and their gross sales, as well as the 2 highest and 2 lowest gross sales?