Below is my XML data

<Report>
<Inquiries>
  <Inquiry>
    <MemberCode>57</MemberCode>
    <MemberName>INC.</MemberName>
    <Date>30</Date>
  </Inquiry>
  <Inquiry>
    <MemberCode>53</MemberCode>
    <MemberName>CO.</MemberName>
    <Date>10</Date>
  </Inquiry>
  <Inquiry>
    <MemberCode>49</MemberCode>
    <MemberName>VE</MemberName>
    <Date>13</Date>
  </Inquiry>
  <Inquiry>
    <MemberCode>39</MemberCode>
    <MemberName>DESJA</MemberName>
    <Date>09</Date>
  </Inquiry>
  <Inquiry>
    <MemberCode>54</MemberCode>
    <MemberName>DA</MemberName>
    <Date>21</Date>
  </Inquiry>
  <Inquiry>
    <MemberCode>82</MemberCode>
    <MemberName>LOANS</MemberName>
    <Date>17</Date>
  </Inquiry>
</Inquiries>

**I want only the all tags under like below **

<MemberCode>57</MemberCode>
<MemberName>INC.</MemberName>
<Date>30</Date>

1.Below is the snowflake query used to determine column values.

    SELECT  top 100
                KEY,
                b.VALUE
                ,b.this
                
                ,GET(XMLGET(XML_DATA,'Report'),'$')::string as first_level
                ,XMLGET(XMLGET(XML_DATA,'Report'),'Inquiries') as second_level
                ,XMLGET(XMLGET(XMLGET(XML_DATA,'Report'),'Inquiries'),'Inquiry') as third_level
                
               ,GET(b.VALUE,'@')::STRING as name
            ,CONCAT(XMLGET(b.VALUE,'MemberCode'):"$",
            XMLGET(b.VALUE,'MemberName'):"$",
            XMLGET(b.VALUE,'Date'):"$") AS MAIN_VALUE,
            
            from
                 FULL_XML,
                LATERAL FLATTEN(XMLGET(XMLGET(XML_DATA,'Report'),'Inquiries'):"$") b;

2.With above query I get same value for both second_level and third_level. Need Help in getting only tags under