Wants an inventory report that lists all of the inventory the store has ever carried (both animals and merchandise). Use

Wants an inventory report that lists all of the inventory the store has ever carried (both animals and merchandise). Use

Question:

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.

Expert Answer:

Answer rating: 100% (QA)

SQL Query for the above problem is given by SELECT AnimalID AS ID Name Breed AS Description Category
View the full answer