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...

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.