Finding Item's distribution over customer routes
select sd.item, 
       sd.brand,
       cm.Route,
       cm.Route, 
       count(*) as TotalCustomersCount 
from SalesData sd with (nolock)
  inner join CustomerMaster cm 
    on sd.CUSTOMERCODE=cm.CODE
group by cm.ROUTE


I am not sure what BuyingCustomersCount is.