This reference takes an in depth look at setting up alerts for queries

Setting Up An Alert
In the Alerts view, you'll see all existing alerts and an option to create a new one. To set up a new alert you'll need to follow these...
Wed, 27 Dec, 2017 at 11:01 AM
Alert Status & Frequency
Wed, 27 Dec, 2017 at 10:56 AM
Multiple Column Alert
There's an indirect way to set an Alert based on multiple columns of a query:  Your query can implement the alert logic and return a boolean value ...
Wed, 27 Dec, 2017 at 11:03 AM