title: SQL Query on Json object inside multiple JSON objects
body: <p>I have the below Json string. I need to write a query to get the TP records. Without providing the index value, we need get the result.</p>
  
  <pre><code>{
     "S": [
      {
        "Name": "Project1",
        "SP": [
         {
            "ID": 1,
            "Name": "Test1",
            "TP": [
              {
                "TID": 11,
                "TName": "TT1",
              },
              {
                "TID": 12,
                "TName": "TT2",
              },
           ]
        },
        {
          "ID": 2,
          "Name": "Test2",
          "TP": [
           {
            "TID": 13,
            "TName": "TT3",
           },
           {
            "TID": 14,
            "TName": "TT4",
           },
         ]
      },
    ]}]}
  </code></pre>
  
  <p>How do I query to get the TP values.</p>
  
  <p>Expected Result:</p>
  
  <pre><code>  TID    TName 
    11     TT1 
    12     TT2
    13     TT3
    14     TT4
  </code></pre>