The UNNEST function converts one or many arrays into a table. The result table includes a row for each element of the specified array. The result of the UNNEST function needs to be assigned to a table variable
ARRAY_AGG ( )– Function can be used to convert a column of an Internal Table to an Array. its opposite to UNNEST