Question

XQUERY QUESTION

Suppose you have two .xml documents called file one and file two
====================================FILEONE==============================================

<?xml version="1.0" encoding="UTF-8"?>
<banks>
<bank bid="p123">
<checking>
<name>ashley</name>
</checking>
<savings>
<name>bill</name>
</savings>
</bank>
<bank bid="p456">
<checking>
<name>Joe</name>
</checking>
</bank>
<bank bid="p789">
<checking>
<name>doug</name>
</checking>
<savings>
<name>ashley</name>
</savings>
</bank>
</banks>
==========================================================================================

===================================FILETWO===============================================

<?xml version="1.0" encoding="UTF-8"?>
<bankCustomer>
<account type="checking,savings" name="ashley">
<banks>
<bid>b123</bid>
<bid>b789</bid>
</banks>
</account>
<account type="savings" name="bill">
<banks>
<bid>b123</bid>
</banks>
</account>
<account type="checking" name="doug">
<banks>
<bid>b789</bid>
</banks>
</account>
<account type="checking" name="Joe">
<banks>
<bid>b456</bid>
</banks>
</account>
</bankCustomer>

==========================================================================================

We are asked to convert file1 to file2 using a xquery using this website to test it Testing http://www.xpathtester.com/xquery

Please Help!