The purchasing department at AdventureWorks need to know at a glance what the credit rating is of the various companies they deal with. Write a query to create this list for them.

From the WorldWideImports database's [Sales].[Invoices] table, create a query that shows the [CustomerID] and [DeliveryInstructions] of each invoice and sort by the [CustomerID] column. Include in the query results an expression column that uses the [TotalDryItems] value but uses the following wording instead of the actual number. Call the new column "DryItems";

0 = None 1 = One 2 = Two 3 = Three 4 = Four

if the value is not in this list, show 'Five or more'

Use SSMS and paste your SQL here