Question: 8. Write a query to display shipper id, shipper name , (len*width*height *product_quantity) as total volume shipped and show Which shipper has shipped highest volume

 8. Write a query to display shipper id, shipper name ,

8. Write a query to display shipper id, shipper name , (len*width*height *product_quantity) as total volume shipped and show Which shipper has shipped highest volume of items. (1 ROW) [NOTE : SHIPPER TABLE, ORDER_HEADER TABLE, ORDER_ITEMS TABLE, PRODUCT TABLE] 9. Write a query to display carton id , (len*width*height) as carton_vol and identify the optimum carton (carton with the least volume whose volume is greater than the total volume of all items) for a given order whose order id is 10006 , Assume all items of an order are packed into one single carton (box) . (1 ROW) [NOTE : CARTON TABLE] 10 . Write a query to display product id, product description, total_quantity (sum(order_quantity) , Provided show the most and least sold products (quantity-wise) . (3 ROWS) (USE: SUB-QUERY)

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 Mathematics Questions!