Hi
I would like to get the ouput like below from the given XML data. Can you please help me to frame the SQL query
Output
classWise_BookedCount | classWise_CheckinCount |
---|
000F/007J/174Y | 000F/007J/172Y |
XML
<root>
<bookedCount>
<classWiseConfiguration load="0" classCode="F"/>
<classWiseConfiguration load="7" classCode="J"/>
<classWiseConfiguration load="174" classCode="Y"/>
</bookedCount>
<checkedInCount>
<classWiseConfiguration load="0" classCode="F"/>
<classWiseConfiguration load="7" classCode="J"/>
<classWiseConfiguration load="172" classCode="Y"/>
</checkedInCount>
</root>
Thanks,
Venkataraman L