SuperTutor

(15)

$15/per page/Negotiable

About SuperTutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Business & Finance See all
Accounting,Business & Finance,Economics,Engineering,HR Management,Math Hide all
Teaching Since: Apr 2017
Last Sign in: 327 Weeks Ago, 5 Days Ago
Questions Answered: 12843
Tutorials Posted: 12834

Education

  • MBA, Ph.D in Management
    Harvard university
    Feb-1997 - Aug-2003

Experience

  • Professor
    Strayer University
    Jan-2007 - Present

Category > Programming Posted 18 May 2017 My Price 9.00

1MGS 404 – Fall 2016A

please read carefully and you have to finish homework on time.  

 

1MGS 404 – Fall 2016Assignment 4Due Date: October 24, 2016 in classTotal Points: 30For all the exercises below copy and paste your queries, and paste the screenshot of the resultyou obtained. Submit printed hard copies.Using the PART table you created previously (for reference see the table at page 2).1)Display all the part numbers and descriptions in the same column, with a ‘-‘ between thepart number and the description. (7.5 points)2)For all the parts, display the part number and inventory value (Inventory = on_hand * price).The display should be sorted by the inventory value, with the inventory value rounded andno decimal places are listed. (7.5 points)3)Display the total inventory value (Inventory = on_hand * price), for all the parts inWarehouse 1. (7.5 points)4)What is the part number, description and price of the most expensive part in the partstable? (7.5 points)Hint: Use a subqueryBonus Question:(5 points)5)Display how many different classes the PART table has. (Hint: Use “COUNT” function)

Attachments:

Answers

SuperTutor
(15)
Status NEW Posted 18 May 2017 06:05 AM My Price 9.00

-----------

Attachments

file 1495088448-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)