anyIf
Description
The If combinator can be applied to the any
aggregate function to select the first encountered element from a given column
that matches the given condition.
Example Usage
In this example, we'll create a table that stores sales data with success flags,
and we'll use anyIf to select the first transaction_ids which are above and
below an amount of 200.
We first create a table and insert data into it: