Retrieve details of reference from a list

SQL++
1

Hi,
Can you help me to construct a N1QL query to fetch all countries details of all references from the structure below

[

{
“name”: “1”,
“code”: “1”,
“countries”: [

    {
      "_type": "Country",
      "id": "212"
    },
    {
      "_type": "Country",
      "id": "92"

    }
]

},
{
“name”: “2”,
“code”: “2”,
“countries”: [

    {
      "_type": "Country",
      "id": "100"
    }
]

},

]

thanks