Assignment title: Information


1. List the patient id, accession id, animal name, and breed for all animals, sortedby animal type, that are currently being treated (where they have not beenreleased, 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 monthgrouped byi. Local government areaii. Cause of afflictionb. List the total number of accessions for this month in the previous years.3. List all Carer Groups with an expired permit.