You suspect certain employees are not servicing very many shipments, and some may not have any...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You suspect certain employees are not servicing very many shipments, and some may not have any shipments at all. Create SQL to run a report which will a. List all your employees and the customers they serviced along with the number of shipments for each customer. Include all employees, including those who may not have serviced any customers. b. Note you want the number of shipments, not the sum of shipment quantity. For example, if you have one shipment of 10 units, and another shipment of 20 units, our number of shipments here is 2. c. Sort the list ascending on number of shipments (so the smallest numbers of shipments are at the top), and then on employee id. If an employee has not serviced any customers, display that employee at the very top. For the Question 4, you may want to review the SQL Aliases functionality ("select X from Y as Z"). There is a section in WWW3 SQL schools on this. You also may find the following syntax helpful. If we have a table named "table" with columns A and B in it, "select table.RecordID table.A table.B. (table.A + table.B) as Answer from table;" will give you the following. The (table.A + table.B) performs the addition for each row, and the "as Answer" uses aliasing to give your output an easy to read name. 1 2 3 RecordID A 3 4 1 B 6 0 2 Answer 9 4 3 You suspect certain employees are not servicing very many shipments, and some may not have any shipments at all. Create SQL to run a report which will a. List all your employees and the customers they serviced along with the number of shipments for each customer. Include all employees, including those who may not have serviced any customers. b. Note you want the number of shipments, not the sum of shipment quantity. For example, if you have one shipment of 10 units, and another shipment of 20 units, our number of shipments here is 2. c. Sort the list ascending on number of shipments (so the smallest numbers of shipments are at the top), and then on employee id. If an employee has not serviced any customers, display that employee at the very top. For the Question 4, you may want to review the SQL Aliases functionality ("select X from Y as Z"). There is a section in WWW3 SQL schools on this. You also may find the following syntax helpful. If we have a table named "table" with columns A and B in it, "select table.RecordID table.A table.B. (table.A + table.B) as Answer from table;" will give you the following. The (table.A + table.B) performs the addition for each row, and the "as Answer" uses aliasing to give your output an easy to read name. 1 2 3 RecordID A 3 4 1 B 6 0 2 Answer 9 4 3
Expert Answer:
Related Book For
Posted Date:
Students also viewed these databases questions
-
make a report which will give you information about shipments sent by your lower-commission employees. Create a query which will Include only all those shipments which were sent by an employee whose...
-
importance of workalike balance for women as a leader in healthcare. 1. The purpose of the research; 2. Research question/s; 3. Findings and relevant data; 4. Any recommendations and; 5. The...
-
Determine a house of quality for a ballpoint pen. In the house of quality, fill in three customer requirements. Determine one technical requirement for each customer requirement and fill it in....
-
In 2017, Rose, Inc., has QPAI of $4 million and taxable income of $3 million. Rose pays independent contractors $500,000. Rose's W-2 wages are $600,000, but only $400,000 of the wages are paid to...
-
Judge Robert Smith is accused of being soft on crime, especially in cases involving white collar crimes like fraud and embezzlement. The judge has responded to the accusation by insisting that the...
-
Consider two plates at temperatures of \(600 \mathrm{~K}\) and \(500 \mathrm{~K}\) with emissivities of 0.8 and 0.4 , respectively. The plates are separated by a gray gas that has an absorption...
-
The following data were adapted from a recent income statement of Procter & Gamble Company: (in millions) Net sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ....
-
Table below shows the demand for haircuts from seniors and other customers on an average weekday in the local hairdressing shop. Price of Haircut Quantity Demanded by Seniors 2 Quantity Demanded by...
-
Using the table for nursing labor, calculate the Actual Cost and how you will divide the nursing labor expense based on skill mix. Consider safe staffing requirements, quality of care and operational...
-
A local deli prepares fresh potato salad for its customers every day. The unsold salad has to be thrown away. The demand for potato salad can be classified as low (100 lb), medium (200 lb), or high...
-
Are global companies expanding, or are they in retreat? What does the evidence show?
-
Compare and contrast a divisional structure with a matrix structure. In which type of environment might each be best suited?
-
What does culture eats strategy for breakfast mean?
-
Why should high profitability projects be viewed with some skepticism?
-
Fix the email. Correct spelling mistakes, add commas, take out repetition, etc. To: Jessica Wu-Santana From: Martin Fitzgerald, Manager CC: Date: November 4, 2018 Re: Suggestion for Telecommuting...
-
a. What is the cost of borrowing if Amarjit borrows $28 500 and repays it over a four-year period? b. How many shares of each stock would he get if he used the $28 500 and invested equally in all...
-
Holden Inc. sells one major product. Purchase prices have been rising steadily for this product for several years. Which of the following inventory costing methods would tend to provide the lowest...
-
Describe in a general way the purpose of the statement of cash flows and the information that it conveys.
-
Golden Bakery acquires a delivery truck for $60,000 and anticipates using it for eight years, at which time it will have logged 500,000 kilometres. Currently, market conditions suggest that a used...
-
The group \(\mathrm{D}_{3}\) in Schoenflies notation (32 in international notation, which is read "three-two"; see Table 5.1 ) consists of the proper (those not reflections or inversions) covering...
-
Derive the two-dimensional matrix representation Tic)=(2) Tin)=(3) Tex)=(37) (69) T(c2b)= 1 TO)-(71) 10-(11) TO=(9) = for the group D3, using the basis (e1, e2) defined in the following figure.
-
Prove that the matrix representation of \(\mathrm{D}_{3}\) worked out in Problem 5.6 is irreducible. Data from Problem 5.6 Derive the two-dimensional matrix representation Tic)=(2) Tin)=(3)...
Study smarter with the SolutionInn App