Reference no: EM131325217
Question 1: For each part, show the Sales Orders that sold that part. Show the Parts that have no sales as well. Display the PartID, Part Name, Sales Order #, the Quantity sold and the price for the order.
Hint: A Left Join returns everything already selected even if it doesn't match the tables following. An Inner Join only returns those rows that match the condition in both tables. A Right Join is the opposite of a Left Join: It returns rows in every table AFTER the join even if the previous rows are not matched.
Question 2: For each Part, show the PartID, Part Name, Total Quantity sold and the total sales, including Parts with no sales. Order by the quantity sold descending, then by the name of the part.
Hint: Aggregrate columns return results based on "groups" of rows. If you select a non-aggregrate column, your query must GROUP BY those non-aggregrate columns. To convert NULL to 0, use IsNull(column name, 0), for example IsNull(OrderCost, 0).
Question 3: For each Sales Order, show how many days it took to ship the order in order by the longest order, then by Sales Order Number. Display Sales Order Number and the number of days to ship. Include the orders that have not yet shipped.
Hint: Look at the DATEDIFF function to return the difference between two dates. The two dates in this problem are the Order Date and the Shipment Date.
Question 4: Show the orders that are partial shipments meaning that the quantity shipped is less than the quantity ordered. Display the SalesOrderNumber, PartID, Quantity Ordered and the Quantity Shipped in order by SalesOrderNumber, PartID.
Hint: All of this information comes from two tables: SalesOrderPart and ShipmentPart. use the WHERE statement to find the rows where the SalesOrderPart Quantity is greater than (use '>') the ShipmentPart Quantity.
Question 5: Show the total sales by year. Display the year and the total sales. Sort by year.
Hint: Try using the YEAR( some date ) function and the SUM( some column ) aggregate function. Don't forget your GROUP BY. Note that YEAR( some date ) is a function and not an aggregate meaning that it must be in the GROUP BY expression.
|
What is an example of a recent creative sourcing strategy
: What is an example of a recent creative sourcing strategy used by a company and how successful was it?Share other sourcing strategies you personally think are creative,Please describe them,Share why you think they are creative.
|
|
What is the relationship between beauty
: By contrast, Plato (in The Republic) warns of poetry's power to make a falsehood seem true, by beautifying it. What, then, is the relationship between beauty, as achieved by the artist, and truth?
|
|
What are the three most important ideas presented and why
: Read "Current Approaches to HR Strategies: Inside-Out versus Outside-In" found in the Kaplan Online Library. In your opinion, what are the three most important ideas presented and why
|
|
What are the benefits of creating trust for a leader
: Explain the leader's role within a team meeting to build trust and cohesiveness between the leader and team members. What are the benefits of creating trust and cohesiveness for a leader?
|
|
Show how many days it took to ship the order in order
: For each Sales Order, show how many days it took to ship the order in order by the longest order, then by Sales Order Number. Display Sales Order Number and the number of days to ship.
|
|
What does this quote tell you about mrs. mallard
: There would be no zwerfuLahatsliam in that blind persistence with which men and women believe they have a right to impose a private will upon a fellow creature." What does the passage, specifically the underlined parts show?
|
|
What are your immediate reactions after watching video
: What are your immediate reactions after watching the video? Explain.How do you think the team will be affected after this?What suggestions would you give and how would you communicate your suggestions to the leader of the team.
|
|
What does northern need to do to realize the benefits
: What went wrong with the TUFS investment and what can be done to prevent these problems in the future? What does Northern need to do to realize the benefits that were projected for TUFS?
|
|
Identify the frame used by the leaders in the challenger
: Identify the frame(s) used by the leaders in the Challenger and Columbia situations (i.e., Structure, HR, Political, and Symbolic). Review the choice of frames made by the management in those situations. Explain if the situation with the space shut..
|