Can I get help with this assignment. I am attaching the database to be used with this assignment. Northwind is the database to be used. Thanks.

CPT 242 Summer 2014 SQL Assignment 3 - Using Multiple Tables Revision Date: 1/7/2015 Rmber when using 2 or more tables you must join the tables together. The number of joins you will use is the number of tables -1. In other words, if you use 2 tables you will have 1 join statement,3 tables you will use 2 joins etc. ** 1. Using EXPLICIT Join syntax, list the CustomerlD, Contact Name, Address, City, State (region) and Postal code from the Customers table along with the orderld, and Orderdate from the orders table for orders placed in July 2014 2. Using the IMPLICIT join syntax recreate the code from Question1 3. Write a query that returns the following columns: Customerld, Company name from the Customers Table Order ID from the Orders Table Show all customers regardless of whether they have any orders. Sort the results by Order ID. 4. NorthWind traders wants to know the following information about their orders for products supplied by Supplier number 12 and fulfilled by employee number 2 a. The first and last name of the employee who took the order b. The customer name (company name) of the customer who placed the order c. The ordered and the shipped and required date d. The product ld and Product name of the item(s) ordered e. The ID and name of the supplier f. The shipper ld and company name Sort the output by order date then by customer ID. Since several of the fields use the same name use column aliases where needed to differentiate between the columns with the same names 5. List the Orderid, customerID, orderdate, unitprice and Quantity for all orders with a quantity under 12. Use Correlation names. 6. Use the UNION keyword to return 2 columns from the Customers table, Company name and country. If the Country is USA the country value should be "Inside USA". Otherwise the country value should be "Outside USA