Continue working on your Order database on the following queries using SQL state

Question

Continue working on your Order database on the following queries using SQL statements. Copy and past 1) query question, 2) SQL statement and 3) SQL output to a word file, and print it out.

1. Retrieve the average, highest, and lowest price of each product finish.

2. Display customer names who have made 2 orders.

3. Display the order IDs and the number of products placed for each order.

4. Create a view for customer in Texas and New York.

Example for three output: Query, SQL and output Display the SKU description for the buyer “Pete Hansan”. SELECT SKU_DESCRIPTION FROM SKU_DATA WHERE Buyer = 'Pete Hansen';

CUSTOMER CustomerlD CustomerName CustomerAddress CustomerCity CustomerState CustomerPostalCode ORDER OrderlD OrderDate CustomerlD ORDER LINE OrderlD ProductID OrderedQuantity PRODUCT ProductID ProductDescription ProductFinishl ProductStandardPrice ProductLinelID

Explanation / Answer

1)

SELECT avg(ProductStandardPrice) as average, max(ProductStandardPrice) as highest, min(ProductStandardPrice) as lowest from Product OrderBy ProductId;

2)

select CustomerName from Customer where (Count(Unique(Order.CustomerId)) >2);

3)

Select OrderId, OrderedQuantity as number of products from Order Line OrderBy OrderId;

4)

Create View V_CUSTOMER as select CustomerState="texas" & "New York" From Customer;

Created all queries

Thank You

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.