Use the tables given below to answer the following questions (a) - (1) Customers table cust_id cust_name 3001 Nick Rimando 3002 Brad Davis cust id city New York New York California 3003 Graham Zusi 3004 Julian Green London Orders Table ord_no purchase_amount ord_date 70001 150.5 10/5/2012 3005 70009 270.65 9/10/2012 3001 70002 6526 110/5/2012 3002 70004 110.5 8/17/2012 3004 70007 948.5 9/10/2012 3005 70005 2400.5 7/27/2012 3005 70008 5760 9/10/2012 3002 70010 1983.43 20/10/2012 3004 70003 24804 170/10/2012 3001 a) Write SQL code that will create the table named Customers. [3 marks] b) Write SQL commands to insert the folli 2) Write SQL code that will create the table named Customers. [3 marks] ) Write SQL commands to insert the following customer in the table Customers: cust_ Johnson, city='New York[2 marks] c) Display the details of customers who are from New York. [2 marks] d) Display customer name and city from table Customers with city in descending order. [1 mark e) Write codes to change the customer's name to Fedrick Niche for the customer with id = 3003. Display all orders that were placed by cust_id = 3001. [2 marks] g) Display purchase amount order date and customer id in the order in which the customers had p