HIM 3113 Lecture Notes - Lecture 3: Species Description, List Of Fables Characters
Document Summary
In this lab, we will be referencing the hairy vet database. In the space below each question, enter your code and your output below. Make the column headings last name , first name , color and species respectively. Sort the output by last name and then first name. Select *lname* as last name ,*fname* as first name ,**,color as color ,*species* as. Species from ***** where *species* between 3" and 5" or color=5 and *lname*="marselis order by *lname*; Output: list the, pet"s last name (the client"s last name and the animal"s first name), color, and species for all sheep that are black. Write the query with the words as the search criteria (don"t look up the id for sheep search on the word sheep). Add aliases of last name, first name, color, and species. Select *lname* as last name , *fname* as first name , color as color , species as.