Cacher is the code snippet organizer for pro developers

select SUM(units)
from vw_ce_dms_transactions
where TransactionDateTime between '20180101' and '20180107'
and TransactionType like '%loading%'
and cancelled = 0