HIM 3113 Chapter Notes - Chapter 4: List Of Fables Characters
21 Apr 2016
School
Department
Course
Professor
Document Summary
Dates and string functions: hairy vet wants to reward long-term cat clients. Help the office by creating the following listing if: the animal"s appointment was over 6. 5 years ago. Years since last appointment date (with title years since last appointment) rounded to 1 decimal place. Months since last appointment date (with title months since last appointment) (use the months between function) use the months between function. Sort the output by animal last name ascending, descending years since last appointment. Output: write a query that shows the client"s name and the length of the animal"s name if the animal"s name includes the letter b . Show the client"s name as though it was one field in all capital letters with the format of. Last name, first name (such as bradshaw, carrie). Add a column that shows the length of the animal"s first name. Limit the output to animals with a name that has a b in it.
