MYSQL Server 2012 is very confusing when you have an instructor for online course that doesn't amswer questions or provide any backup support to material in the book. I'm attaching two files that I need your assistance on. You did an awesome job  the last time and thank you in advance for same again.

Both files are using MYSQL Server 2012 Northwind Database.

 

CPT 242SQL Assignment 41. Show the average price, lowest price and highest price for all products. Name the columns to match thefunction being used.2. Show the customer ID and the Average Freight Charge for each customer3. Show the same information in step 2 but only for customers who have an average freight cost more than $100.4. Show each Employee’s ID along with their first and last name and their most recent order date.5. Show the product Id and the number of times the product has been ordered for products ordered more than50 times. HINT: use the order items table **6. Display the OrderID, the pre-discount price (name the column Full Retail Price) for all orders and the finalprice (name the column Final Price) for all orders.**bonus points for displaying only 2 numbers to the right of the decimal in the Final Price Column***7. Northwind traders would like to know how many times each shipper has shipped each product.Write a select query that returns the product ID, Product name, shipperId and Shipper name and a field thatshows how many times the shipper has been used for each product.

CPT 242SQL Assignment 51.Find outhow manyorders were shipped late.An order is shipped late if the shipped date is later than therequired date.Call the expression Shipped Late.2.List the Product ID, Product Name, Units in Stock and CategoryID of all products in Category 2whose number of units in stock is more than average of all products. **Hint: Use a subquery3.List the Product ID, Product Name, Units in Stock and CategoryId of all products whosenumber ofunits in stock is more than the average units in stock of the products in Category 2.**Hint:Use a subquery4.Using a subquery, list the Customer ID, Contact name, and country for all customers who do not live inUSA, UK, Australia or Canada.5.Using a subquery find all customers with no orders.6.List the Employee ID and employee name (concatenate first and last names) who report to AndrewFuller.Order the list by last name.7.Show the Customer ID, Company Name and Contact Name of all customers with a company name thatis, at most, 12 characters in length.

• 1495586701-SQL Assignment 5.pdf
• 1495586702-SQL Assignment 4.pdf

ComputerScienceExpert

(11)

Status NEW Posted 24 May 2017 12:05 AM My Price 9.00

-----------

Attachments

file 1495586703-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer