-- Use WideWorldImporters for all questions.

use [WideWorldImporters];

-- Note that the Midterm Part 1 of 2 is worth 10 points

-- This midterm file, Part 2 of 2, is worth 20 points.

-- Together both parts are worth 30 points, as posted.

---------------------------------------------------------------------------------

-- 1. Write a SELECT statement that displays all fields and records for the Sales.Customer table.

-- In your SELECT list each of the fields in the table (i.e. do NOT simply use SELECT *).

-- 1 point.

---------------------------------------------------------------------------------

-- 2. Develop a display message for customers, displayed all in one column,

-- structured as follows:

--

-- Welcome back, Aakriti Byrraju. Your credit limit is: 3500.00

--

-- If a customer has no credit limit, use the ISNULL() function to

-- display (Pending) instead, as in this example:

--

-- Welcome back, Wingtip Toys (Yaak, MT). Your credit limit is: (Pending)

-- 4 points.

---------------------------------------------------------------------------------

-- 3. Display a list of all of the products supplied by Litware, Inc.

-- Sort by product name.

--

-- Note: Though you will need to view several tables to research this,

-- your final answer should be one SQL statement based on one table.

-- I do NOT intend for your to create a join as we have not yet covered joins.

-- 3 points.

---------------------------------------------------------------------------------

-- 4. Using the Sales.Orders table, display 3 columns:

-- the order date,

-- the expected delivery date,

-- and then write an equation that displays the order date minus the

-- expected delivery date and name this new column ShippingDays.

-- 3 points.