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

) 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!