MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Records: 3  Duplicates: 0  Warnings: 0

Records: 4  Duplicates: 0  Warnings: 0

result
{ "Orders": [ { "Id": 1, "Items": [ { "Id": 1, "Qty": 3, "Price": 20, "Total": 60.00 }, { "Id": 2, "Qty": 2, "Price": 30, "Total": 60.00 } ], "Value": 120.00, "Customer": "Joe BLoggs" }, { "Id": 2, "Items": [ { "Id": 3, "Qty": 2, "Price": 35, "Total": 70.00 }, { "Id": 4, "Qty": 1, "Price": 70, "Total": 70.00 } ], "Value": 140.00, "Customer": "Sam Rockstar" }, { "Id": 3, "Items": [], "Value": 0.00, "Customer": "Jack Jones" } ] }

result

{
"Orders": [
{
"Id": 1,
"Items": [
{
"Id": 1,
"Qty": 3,
"Price": 20,
"Total": 60.00
},
{
"Id": 2,
"Qty": 2,
"Price": 30,
"Total": 60.00
}
],
"Value": 120.00,
"Customer": "Joe BLoggs"
},
{
"Id": 2,
"Items": [
{
"Id": 3,
"Qty": 2,
"Price": 35,
"Total": 70.00
},
{
"Id": 4,
"Qty": 1,
"Price": 70,
"Total": 70.00
}
],
"Value": 140.00,
"Customer": "Sam Rockstar"
},
{
"Id": 3,
"Items": [],
"Value": 0.00,
"Customer": "Jack Jones"
}
]
}