This is Ethan. You could separate sales for each location using sub queries with an OUTER JOIN.
If you need custom solutions such as Advanced SQL Queries, Rules Engine, Custom Reports, API Solutions or Integrations, please feel free to reach me at email@example.com
Working on script for sold statistics but because I some products are two locations I have duplicate SKU in my final result .
Tried to use DISTINCT but it does not work form me well.
Need to have it without duplicated SKU. Anyone?