Trigger Gives an Error on Multiple Rows SQL SERVER
since INSERTED can contain more than one row the update could be performed using a join and not fillin single valued variables:

UPDATE C 
SET AccountTypeID = 8 
FROM Customer as C on INSERTED as I on I.AccountNumber = C.AccountNumber
WHERE I.TotalSales between 0 and 5000