Display total qty sold of each item of each store

Thank you.



This is my actual testing data.

so i have multiple store numbers.

My UPC is my item.

Could you explain in more detail how to apply PIVOT to display multiple Store# columns?



I was gonna SELECT multiple StoreNumber in columns like this,

SELECT [UPC]
      ,a.[StoreNumber] As '902-16'
      ,b.[StoreNumber] As '906-CA'
      ,c.[StoreNumber] As '908-KE'
      ,etc....

but that would means i need to inner join multiple inner select statements?