Returns a valid JSON array string of nvarchar (max) type. For more info about what you see in the output of the JSON_ARRAY function, see the following articles: How FOR JSON converts SQL Server data ...

Constructs a JSON array from an aggregation of SQL data or columns. To create a JSON object from an aggregate instead, use JSON_OBJECTAGG. Optional. The order of elements in the resulting JSON array ...