Question: 3 . ( Use Sally s Pet Store ) Sally wants an inventory report that lists all of the inventory the store has ever carried
Use Sallys Pet Store Sally wants an inventory report that lists all of the inventory the store has ever carried both animals and merchandise Use the UNION operator to generate the result set consisting of five columns. The first column called ID should be the ID of the animal or item. The second column called Description should be the description of the item or a concatenation of category and breed with a space dash space in between such as Cat Siamese for animals. The third column called LPrice should list the listprice of the animal or item. The fourth column called Type should be a text tag of Animal for animals and Merch for merchandise items. Sort the final result set by listprice descending.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
