Write your own criteria

In this exercise we will complete the Criteria Table ourselves, based on the requirements.

You can complete this exercise on DataCamp using in-browser Excel, or locally if you have Excel installed.

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

Our criteria for this exercise: Order Item IDs with Sales > $1000 in California.