Q7. PI/SOL: Answer the following Questions Based on the following tables: (10 points) CUSTOMERS Cast to Custame 1066 Bundy Shoe 13144 Target 1776 Harry Store 2001 Kmart 2002 Osboe Street Tow Postcode Kings St Bandera 3083 High Sc Clayton 3800 Elphin Rd Hawthorn 3122 Burke Rd Kew 3101 Glee Rd Kew 3101 500 3000 500 500 1000 450 3000 500 0 1000 PRODUCTS Prod_cod Description Prod group Remake Remake sty 5 3 15 MO9 L09 STI LTI LT9 GN9 STI GA2 Male Runner Lady Runner Girls Runner Tennis Shoe Tennis Shoe Beach Sandal Slipper Soccer Shoe Male Shoes Female Shoes Female Shoes General General General General Male Shoes Prod price 150 250 300 450 100 10 50 500 Oly on hand 6 1 10 1 20 100 50 10 3 1 $ 2 15 150 35 15 20 200 20 40 ORDERS Order no 0001 Order_date 01/07/05 02/07/05 02/07/05 Cast no 13144 13144 0002 0003 1066 ORDER DETAILS Order no Prod cod 0001 STI 0001 GA2 0002 0003 Order ty 10 2 5 10 STI GNO A. Write a stored procedure which receives a customer number (Cust_no) as input, and displays the list of orders made by the customer together with the total price of each of the orders Notes: (columns to display: order_no, order_date, total_price: (Prod price Order_qty) (using the DBMS_OUTPUT.PUT_LINE)