The purpose of this assignment is to familiarize with XQueries. Write an XQuery for each of the following queries (q1.xq, q2.xq, ...) and test them on the premiere xml documents included in "basex\premiere" folder of the BaseX package (tables, SQL script, and schema):

1) For each customer, output

a) customer number and customer name

b) firstname, lastname of the corresponding rep

c) total number of orders placed by that customer

2) Output the customer names of each pair of customers who are associated with the same rep.

There should not be any duplicate reversed pair and no customer be paired with the same customer.

3) For each order number, output

a) name of the customer who placed that order

b) total number of order line items belong to that order

c) total amount of money (excluding tax) billed for that order

4) firstname, lastname of the rep

a) customer name for each customer associated with the rep

b) total amount of money (excluding tax) billed for for all customers associated with the rep

c) For each rep number, output