/* Task 1. Your manager says, "I need a list asset descriptions for items that were once in inventory but have been disposed of. I want the make, model, extended information, and the type of asset it is. Put the list in alphabetical order by make and model. Make the result set have column headers of Make, Model, More Info, and Type. The type is what type of asset is being described. Is it a computer, a server, and application, etc.? If there is more than one of a certain asset description in the results get only one row with the information (that is, assure no duplicate rows).

IT_ASSET_INV_SUMMARY IIHIHIIASSET_INV_SUMMARY_ID ASSET_DESC_ID INV_SUMMARY_DATE NUM_AVAILABLE NUM_ASSGND_USE WIH NUM_ASSGND_SUPPORT CHANGED_BY_USER DATE_UPDATED