can someone help me please 1:Find the highest order total amount and earliest or

Question

can someone help me please

1:Find the highest order total amount and earliest order-date in one query. Show the amount and the date.

2:Find total ship prices for all orders placed by either client 1 or client 2. You need to obtain ONE total, not TWO. In the output, show this total.

3:For clients who have 2 or more orders, find the total amounts paid by each client. Show ClientId, total number of orders, and total paid.

4:

). Counting laptops and desktops together, how many of them are sold and how much revenue have they brought in? (Hint: ItemTotal Column stores revenue. Correct result should return 7 for quantity and $10,320.00 for revenue.)

Shipment!D OrderlD PickUpDate Shipprice DaysToDeliver Click to Add 1 1/3/2017 6 9/19/2016 6 9/21/2016 3 3/30/2016 22/15/2016 8/2/2016 44/15/2016 7 11/5/2016 $25.00 $17.50 $27.40 $38.25 $45.07 $33.03 $27.48 $45.90 2 4 4 (New

Explanation / Answer

1.

Select max(OrderTotal),min(Order_date) from Orders;

2.

Select sum(ShipPrice) from Shipment inner join OrderClient on Shipment.ClientID = OrderClient.ClientD where OrderClient.ClientID = 1 or OrderClient.ClientID = 2 ;

3.

Select ClientId, count(OrderID), sum(PaidAmount) from ClientOrder group by ClientId having count(OrderID) >= 2;

4.

Select count(Quantity), sum(Quantity*UnitPrice) from OrderItem inner join Item on OrderItem.ItemID = Item.ItemID where Item.IName = 'Laptop' or Item.IName = 'Desktop'

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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