For each question write the question, SQL script and the output Include all three in a notepad or word document Do not include screen shots Know how to cut and paste from the SQLplus screen customers custID custLName custFName DateofBirth custCity C1 Attenweiler Shannon 10 Jul 1987 Florence C2 Marksbury Faisal 25 Dec 1965 Blue Ash C3 O'Connell Joseph 12 Feb 1976 West Chester C4 Owen Meghan 11 Mar 1982 Loveland C5 Sullivan Sean 19 Nov 1981 Batavia C6 Weaver John 21 Jan 1963 Dayton C7 Alghanem Kelli 22 Apr 1972 Newport C8 Ballhaus William 6 Oct 1977 Fort Thomas Orders orderID orderDate Amount custID 111 11 Mar 2013 234 45 C1 112 11 Mar 2013 962 89 C3 113 12 Mar 2013 734 46 C4 114 13 Mar 2013 393 76 C5 115 13 Mar 2013 314 34 C2 116 13 Mar 2013 733 23 C4 117 16 Mar 2013 678 89 C1 118 16 Mar 2013 895 34 C6 119 16 Mar 2013 232 64 C6 120 16 Mar 2013 723 29 C8 121 17 Mar 2013 278 34 C3 122 17 Mar 2013 123 45 C6 123 17 Mar 2013 673 45 C4 124 18 Mar 2013 312 35 C2 125 19 Mar 2013 863 34 C5 126 19 Mar 2013 123 45 C3 127 19 Mar 2013 965 76 C1 Questions List the total number of orders for placed from each city List the total value (amount) for each customer List all the orders (ordered, order date, amount) along with customer details (customer name and city) List the customer's name with least total amount of orders List the youngest customer List the number of days past each order

Question: For each question write the question, SQL script and the output. Include all three in a notepad or word document. Do not include screen shots.

For each question write the question, SQL script and the output. Include all three in a notepad or word document. Do not include screen shots. Know how to cut and paste from the SQLplus screen.

customers

custID	custLName	custFName	DateofBirth	custCity
C1	Attenweiler	Shannon	10-Jul-1987	Florence
C2	Marksbury	Faisal	25-Dec-1965	Blue Ash
C3	O'Connell	Joseph	12-Feb-1976	West Chester
C4	Owen	Meghan	11-Mar-1982	Loveland
C5	Sullivan	Sean	19-Nov-1981	Batavia
C6	Weaver	John	21-Jan-1963	Dayton
C7	Alghanem	Kelli	22-Apr-1972	Newport
C8	Ballhaus	William	6-Oct-1977	Fort Thomas

Orders

orderID	orderDate	Amount	custID
111	11-Mar-2013	234.45	C1
112	11-Mar-2013	962.89	C3
113	12-Mar-2013	734.46	C4
114	13-Mar-2013	393.76	C5
115	13-Mar-2013	314.34	C2
116	13-Mar-2013	733.23	C4
117	16-Mar-2013	678.89	C1
118	16-Mar-2013	895.34	C6
119	16-Mar-2013	232.64	C6
120	16-Mar-2013	723.29	C8
121	17-Mar-2013	278.34	C3
122	17-Mar-2013	123.45	C6
123	17-Mar-2013	673.45	C4
124	18-Mar-2013	312.35	C2
125	19-Mar-2013	863.34	C5
126	19-Mar-2013	123.45	C3
127	19-Mar-2013	965.76	C1

Questions:

List the total number of orders for placed from each city.
List the total value (amount) for each customer.
List all the orders (ordered, order date, amount) along with customer details (customer name and city).
List the customer's name with least total amount of orders.
List the youngest customer.
List the number of days past each order.

Step by Step Solution

★★★★★

3.44 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Here are SQL queries for each of your questions along with the expected outputs Question 1 List the total number of orders placed from each city sql SELECT ccustCity COUNToorderID AS TotalOrders FROM ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

How do the actual sample results in Problems 6.48 and 6.49 compare? Obstetrics Figure 6.4b (p. 172) plotted the sampling distribution of the mean from 200 samples of size 5 from the population of...

Do you feel the central-limit theorem is applicable for samples of size 5 from this population? Explain. Obstetrics Figure 6.4b (p. 172) plotted the sampling distribution of the mean from 200 samples...

Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...

The difference between case law and common is which of the following? O Common law creates law and case law interprets existing law. There is no difference. Case law is criminal law and common law is...

Dividend Policy what is the chief drawback to a strict residual dividend policy? What is this a problem? How does a compromise policy work? How does it differ from a strict residual policy?

An advantage of the scattergraph method is that it: a. is objective. b. is easier to use than the high-low method. c. is the most accurate method. d. removes outliers. e. is descriptive of nonlinear...

1. Assign study buddies who can be available over the phone.

In 2006, Ben Bernanke said the goals of strong output growth and low inflation are almost always consistent with each other." Alan Greenspan once called the tradeoff between output and inflation...

I am would like to verify in yellow the numbers I came up with for straight line depreciation for the acquisition date given as well as verify the proposed audit adjustment account below if...

1. Case Exhibit 2 presents monthly data of units produced and sold, and actual costs incurred, for 24 months. B Create a scatterplot of costs and units. b. From your scatterplot, estimate the...

1. To arrive at a more accurate estimate of cash flow we would add depreciation expense to net income. The next step would be to: A. reduce our estimate by the increases in liabilities. B. reduce our...

A BA is documenting their analysis and design experience. Which task covers the question, "What was expected to be delivered?"

27. Question 27 It's the start of a new quarter at Adventure Works. You find yourself in a modern conference room surrounded by department heads and key stakeholders. The focal point of the room is...

Ratino is working on how to process criticism at work so he can influence the conversation to a solution. What is the last step in this process? Select an answer: He should assume positive intent. He...

Brad Gokool is reviewing the results of the subsequent events audit procedures. Brad is writing a report for his audit partner based on these results and will be attending a meeting tomorrow with the...

Which techniques are recommended when communicating data-informed decisions? Select all that apply. a. Defining the problem. b. Assigning blame for the problem. c. Supporting the solution with data....

What is the EAR of a loan with an APR of 7.56 percent, compounded quarterly? Group of answer choices 7.70 percent 7.02 percent 7.78 percent 7.56 percent 7.64 percent

Sandcastles, Inc.s management has recently been looking at a proposal to purchase a new brick molding machine. With the new machine, the company would not have to buy bricks. The estimated useful...

Helen Roberts is reviewing two transactions recorded by her client, Biotechnologies (Biotech), as part of her accounting firms annual audit of the client for the December 31, 2021, financial...

In what some are suggesting is the worst financial reporting fraud since Enron, Wirecard filed for bankruptcy in June of 2020 after admitting that 1.9 billion Euros ($2.1bn U.S.) on its balance sheet...

Joe Kang is an owner and audit partner of Han, Kang & Lee, LLC. As the audit of Frost Systems was reaching its concluding stages on January 15, 2022, Kang met with Kate Boller, the CFO, to discuss...

=+75. Exercise 4 of Chapter 1 presented a sample of n = 153 observations on ultimate tensile strength.

=+deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights...

=+71. Suppose the smallest distance d between any two successive measurements in an ordered set of data (i.e., measurements sorted from smallest to largest) is 3 units.