please answer no4,5 and 6

(a) Consider a 'Customer Order processing' database with three tables as given below 1. Customer - captures customer details cust_no | cust_name 0001 John C002 Joseph C003 Peter C004 Pan 2. Item - captures item details item_no i item_name 1 item_price 10001 Shoes 120.00 10002 Umbrella 100.50 10003 Table 50.00 10004 TV 1000.80 10005 Fan 501.10 3. Orders - captures order details of the items bought by customer order_no order_date | cust_no | item_no i no_of_units_bought 1001 2019-09-08 C002 10001 1002 2019-01-09 C002 10003 1003 2019-01-09 C002 10004 1004 2019-01-09 C003 10004 1005 2019-05-02 C003 10001 1006 2019-01-03 C003 10003 1007 2019-01-01 C004 10001 1008 2019-11-11 C004 10002 1009 2019-11-11 C004 10004 1010 2019-01-09 2004 10003 Based on the tables given above, answer the following questions iv) Write a Stored Procedure to show the details of the item not bought by any customer (use the item and orders table] V Write an SQL statement that shows the customer names and the respective items bought by them as given below Name Items Joseph Peter Pan Shoes, Table, TV Shoes, Table, TV Table, shoes, Umbrella, TV vi) Write an SQL statement to show the customer names of the customers who bought 'shoes' in a horizontal manner. vii) Write an SQL statement to 1) create a view to show total number of customers. 2) find the total number of items bought by each customer as shown below Customer | UnitsBought Joseph 8 Peter 8 Pan 10 COOOO