You administer a Microsoft SQL Server 2012 database. You use an OrderDetail table that has the
following definition.
You need to create a non-clustered index on the SalesOrderID column in the OrderDetail table to
include only rows that contain a value in the SpecialOfferID column. Which four Transact-SQL
statements should you use? (To answer, move the appropriate statements from the list of
statements to the answer area and arrange them in the correct order.)
