the select statement should be:

SELECT

[COMPANYNAME]

,[DISTRICTNAME]

,[STORENBR]

,[BusinessDate]

,SUM(Mature) as Mature

,Sum(Cooking) as Cooking

,Sum(Exercise) as Exercise

,Sum(Math) as Math

,Sum(AudioBooks) as AudioBooks

,Sum(Childrens) as Childrens

,Sum(Spanish) as Spanish

,[STORENAME]

from booksales sales

inner join bookstores stores on stores.storeid = sales.storeid

group by businessdate

, stores.companyname

, stores.districtname

, STORES.STORENBR

, STORES.STORENAME

Order By businessdate, storenbr