You should include the query used on your database design to get that data, and the result of the query on the supplied data set. 1. List the patient id, accession id, animal name, and breed for all...

You should include the query used on your database design to get that data, and the result of the query on the supplied data set. 1. List the patient id, accession id, animal name, and breed for all animals, sorted by animal type, that are currently being treated (where they have not been released, or sent to a carer or other facility). 2. Monthly report (this is multiple queries): a. list the total for all in-coming accessions in the previous calendar month grouped by i. Local government area ii. Cause of affliction b. List the total number of accessions for this month in the previous years. 3. List all Carer Groups with an expired permit