Question: Teradata SQL Customer Table: CS_Name (Primary Key), CS_Number, CS_Type Product Table: PO_ID (Primary Key), CS_Number (Primary/Foreign Key), PO_Date (Primary Key), PO_QTY, PO_AMOUNT, PO_Note Question: List

Teradata SQL

Customer Table: CS_Name (Primary Key), CS_Number, CS_Type

Product Table: PO_ID (Primary Key), CS_Number (Primary/Foreign Key), PO_Date (Primary Key), PO_QTY, PO_AMOUNT, PO_Note

Question: List the ucstomer name and total order amount by customer name only if this total order amount is above 4000. List the results in reverse alphabetical order by customer name.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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!

Teradata SQL Customer Table: CS_Name (Primary Key), CS_Number, CS_Type Product Table: PO_ID (Primary Key), CS_Number (Primary/Foreign Key), PO_Date (Primary Key), PO_QTY, PO_AMOUNT, PO_Note Question:...

SQL Customer Table (cname), agent table (aid), product table (pid), order table (ordno) 1. List the cname and the sum of dollars that each customer ordered. (Functions, GROUP BY) 2. List the cname...

IT 625 Final Project Guidelines and Rubric Overview Note: In order to successfully complete this project, you will need to carefully review the Final Project Guidelines and Rubric document and the...

First Teradata Assignment Using database db_pvfc12_big, based on the diagram in Figure 2-22, write SQL queries to answer the following questions and execute them (finding the correct answers!!)...

Your assignment is to write and execute the SQL queries that will produce the data ( record sets ) requested below using the Pine Valley Furniture database in Microsoft Access and Teradata SQL...

1. Create a new Microsoft Word document and write your full name at the top of the document. 2. Log into your Teradata account and write and run an SQL statement for the problem described below 3....

Use the db_pvfc12_big database in Teradata SQL Assistant. Create a .SQL file that provides queries to the following Problems in the textbook: 15) 5-74. For each payment made on or after March 10,...

Use the db_pvfc12_big database in Teradata SQL Assistant. Create a .SQL file that provides queries to the following Problems in the textbook: 10) 5-69. For every product that has been ordered,...

Using the MDIFF ordered analytical function in Teradata SQL (see the Functions and Operators manual), show the differences (label the difference CHANGE) in TOTAL (which you calculated in the previous...

On January 1, 2018, Crane Company sold the property to Wildhorse Co which originally cost Crane $2740000 There was no established exchange price for this property Wildhorse gave Crane a $4230000...

In Figure the ideal batteries have emfs1 = 12 V and 2 = 6.0 V and the resistors have resistances R1 = 4.0?? and R2 = 8.0??. What are? (a) The current, the dissipation rate in (b) Resistor 1 and (c)...

What is another name for the income statement? cash flow statement balance sheet profit and loss statement taxable income statement

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

(Appendices) COST OF PURCHASES. Compass, Inc., purchased 1,000 bags of insulation from Glassco, Inc. The bags of insulation cost $4.25 each. Compass paid Turner Trucking $260 to have all 1,000 bags...

(Appendices) TERMS OF SHIPMENT AND RECORDING PURCHASES. On May 12, Digital Distributors received three shipments of merchandise. The first was shipped F.0.B. shipping point, had a total invoice price...

(Appendices) SALES AND SALES RETURNS WITH DISCOUNTS. Fuente Office Supply sells all merchandise on credit with terms 2/10, n/30. Fuente engaged in the following transactions: a) May 1: Fuente sold 50...