The MIDRANGE (middle range) function returns a numeric value that is the arithmetic mean (average) of the values of the minimum argument and the maximum argument.
FUNCTION MIDRANGE ( { argument-1 } ... )