Create an XML document and XML Schema for the Projects Schema given in the Exercises at the end of Chapter 5. Now attempt to write XQuery expressions for Exercises 6.32–6.40. Exercises 6.32 List all...

Create an XML document and XML Schema for the Projects Schema given in the Exercises at the end of Chapter 5. Now attempt to write XQuery expressions for Exercises 6.32–6.40.

Exercises 6.32

List all employees from BRICS countries in alphabetical order of surname.

Exercises 6.40

List the total number of employees in each department for those departments with more than 10 employees. Create an appropriate heading for the columns of the results table.