Question: Question 3 Structured Query Language Use the tables given below to answer the following questions (a) - (0) 20 Marks Customers table cust_id cust_name 3001


Question 3 Structured Query Language Use the tables given below to answer the following questions (a) - (0) 20 Marks Customers table cust_id cust_name 3001 Nick Rimando Brad Davis Graham Zusi Julian Green city New York New York California London Orders Table ord no purchase_amount ord_date custid 70001 150.5 10/5/2012 3005 70009 270.65 9/10/2012 10/5/2012 3002 70004 110.5 8/17/2012 70007 9/10/2012 70005 2400.6 T/27/2012 70008 5760 9/10/2012 3002 70010 10/10/2012 1 3004 70003 24804 10/10/2012 1 3001 a) Write SOL code that will create the table named Customers. [3 marks] g) Display purchase amount, order date and customer id in the order in which the customers had placed the orders. [2 marks] h) Display the customer id and total cost of purchase made by each customer. [3 marks] i) Write codes to display the customer id, customer name, purchase amount, order number and order date. [3 marks]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
