Provide a list of all customers by name, the customer’s street address, the customer’s city/state/zip code (concatenated into a single field such as Radford, VA 24142 – do not show the last 4 digits of the zip code and make sure that any extra spaces are eliminated) as Address, the customer’s phone number, the name of the pet and the pet’s date of birth for all animals who are not current on their vaccinations (do not show the vaccination field in your results).
... View more