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 , (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
Get step-by-step solutions from verified subject matter experts
