Northwind Database

SQL Assignment 5 If the question states to use a subquery and a subquery is not used no credit will be given for the question. 1. Find out how many orders were shipped late. An order is shipped late if the shipped date is later than the required date. Call the expression Shipped Late. 2. List the ProductID, ProductName, UnitsinStock and CategoryID of products in Category 2 whose number of units in stock is more than average of all products. **Hint: Use a subquery 3. List the ProductID, ProductName, UnitsinStock and CategoryID of all products whose number of units in stock is more than the average units in stock of the products in Category 2. **Hint: Use a subquery 4. Using a subquery, list the CustomerID, ContactName, and Country for all customers who do not live in USA, UK, Australia or Canada. 5. Using a subquery find all customers with no orders. 6. Using a subquery list the EmployeeID and Employee Name (concatenate first and last names) who report to Andrew Fuller. Order the list by last name. 7. Show the CustomerID, Company Name, and ContactName of all customers with a company name that is, at most, 12 characters in length