Returns the length (number of elements) of the given array.
LENGTH(<arr>)
<arr>
SELECT LENGTH([ 1, 2, 3, 4 ]) AS res;
Returns: 4
4