EQL provides three aggregators for working with sets.
The set aggregate functions can be used only in SELECT clauses.
SET aggregation function takes a single-assign attribute and constructs a set of all of the (non-NULL) values from that attribute.SET_INTERSECTIONS aggregation function takes a multi-assign attribute and constructs a set that is the intersection of all of the values from that attribute.SET_UNIONS aggregation function takes a multi-assign attribute and constructs a set that is the union of all of the values from that attribute.