Question: ) Write an SQL command that will create Sales table which shown in below. 3b) Sales custID custName sales Value date Sales 20 Johnny 4,000

) Write an SQL command that will create Sales table which shown in below. 3b) Sales custID custName sales Value date Sales 20 Johnny 4,000 25/10/2010 (5 marks) Write an SQL command to insert the following information into the Question 2(a) table: customer ID = 38, customer name = Peter, date sales - 11th December 2014, sales value $5,000. (5 marks) Write an SQL command to give Cindy 20% discount. (5 marks) 3c) 3d) Write an SQL command to update Sam record as follows: customer ID = 37 and date sales = 20th October 2010. (5 marks) Write an SQL command to remove Peter's record. (5 marks) 3e) 31) List out how many customers are available in this company
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
