The THE function returns the first element of a list.
If ListExpression contains one or more elements, THE returns the first element of the list. Otherwise it returns an empty list.
Currently, ListExpression must be a SELECT expression.