*/

/*

Question 1

Write an UPDATE statement to change all of the LASTNAMEs in the EMPLOYEE table to SMITH ( 5 marks )

*/

# Put your answer here

/*

Question 2

Write an UPDATE statement to change all of the MAJPROJ records in the PROJECT to AD9999 Where they don't have a value( 5 marks )

*/

/*

Question 3

Write a single UPDATE statement to change the QUANTITY to 200 and the LOCATION to Barrie WHERE the PID has a 1 in the 7th position( 8 marks )

*/

/*

Question 4

Write an UPDATE statement to change the SALARY to be increased by 10% WHERE EMPLOYEE IS older than 40 years old( 10 marks ) (hint date functions to determine age)

*/

/*

Question 5

Write a DELETE statement to remove employee 000030 from the EMPLOYEE table ( 5 marks )

*/

/*

Question 6

Write a DELETE statement to remove records where the total of their SALARY and COMM column together is less than $40000 and they have worked for the company for less than 8 years from the STAFF table ( 7 marks )

*/

/*

Question 7

Write a DELETE statement to remove records WHERE the REGION has South in the name and the SALES DATE is in APRIL in the SALES table ( 10 marks )

*/