-- 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.

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

-- 5. Show all of the J and L stock bin locations that have

-- reorder levels at 20 or more.

-- 4 points.

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

-- 6. Though Wide World Importers has over 600 customers, they have multiple customers

-- in the same delivery zip code. Display the list of each of the customer

-- delivery zip codes without showing the duplicates.

-- 2 points.

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

-- 7. Show the sales orders that were placed

-- ONLY in the month of January in 2014

-- and ONLY in the month of January for 2015.

-- This should be displayed with one SQL statement.

-- 3 points.

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

----- End of Assignment ------------------------------------------------------------------

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