Design and develop database solutions

In Azure SQL Database, an order API expects one JSON object per OrderID in the form {"orderId":101,"products":["A1","B2"]}, with products ordered by LineNumber. Which query returns that shape?