For the purposes of your assignment you are to create queries for the following user reports. The queries should be in the main .sql file but separated by a comment showing which query it is. Eg. # Query 2.a.i You should include the query used on your database design to get that data. 1. List the patient id, accession number, 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 details for Carer Groups with an expired permit.
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here