 This operator supports multiple types of joins, including natural, left-outer, right-outer, and outer joins.Use the SORT operator to sort an input by one or more fields.The TOP expression selects the first k elements of its input.