N1QL query format

Hi All,

Below is the document format that I have stored in couchdb

“A”:{
“B”:
{
“B1”: [
{ “C1”: [ “ticket_number” : “1234”] ,“C2” :[“ticket_number” : “674746”] }]

}
}

suppose i have to get value of ticket_number what will be the query format in N1QL