Simple AND condition

In this exercise we will perform our first sum aggregation on a large dataset, using the relevant functions and criteria!

Database functions are very useful when working with transactional data or event data. They allow for multiple, even complex aggregation conditions in a neat structure of these functions' syntax.

As a reminder, below we display the syntax of one of these database functions, DSUM( ) and a brief recap on Criteria Table:

Our criteria for this exercise: Consumer Sales between 1 Jul 2014 and 1 Sep 2014.