a) A query returning all the appointments vet Dr Foster has in his diary, including the Date and Time of the appointment, the name and species of the patient and the first and last name (in that order) of the patients registered owner; to be useful to Dr Foster the appointments need to be shown in order, the earliest appointment first. For the purposes of this, you can assume that the Appointment table contains all the appointments Dr Foster currently has scheduled.

b) A query returning all the owners registered with Paws For Thought, along with a count of the number of pets each of them has eg Adam Adamson has two pets, David Davison only one.

c) PFT feels that pets should be treated as part of an owners family: to help reinforce this, they like to assign all their patients a family name that matches their owners family name (for example Bodie & Doyles full names would be Bodie Erikson and Doyle Erikson). This also serves a useful purpose of distinguishing between two animals with the same first name. Create a query that shows each patients full name in a single column, their species and breed, and their home address. For the purpose of this query, you can assume that a patient shares their home address with their registered owner d) A query returning the name, species, owners name and total cost of all visits and treatments provided to each patient by PFT. The owners name should be combined into a single column called Owner and the calculated column should have a similarly appropriate name For each of these queries, you should copy the SQL into the document you will be submitting, along with a screenshot of the result you get when you run the query. You may find it useful to use a table of 2 columns and three rows as a framework to help in laying out the SQL and the screenshot consistently together (this avoids some of the issues you can experience with Words object anchoring system).