Principles of Database Management

Create the following SQL Server queries that access the Northwind database. Place them in txt file and place the .txt file in the "drop box" for Assignment 5. 1.List the order ID, customer ID, order date, ship date, and number of days to ship for all orders that shipped within 10 days of ordering. 2. List the order ID, customer ID, company name, order date, and shipped date for all orders that were not ordered on Friday or Monday. 3. List the customer ID, company name, city, country for all customers whose names begin with B, L, or P 4. List the company name for all customers that do not contain the letter B. Northwind Database Structure