Write the SQL code required to list the employee last name, first name of all employees whose middle initial is K.

Write the SQL code required to list the employee number, last name, first name, and middle initial of all employees whose last names start with Smith. In other words, the rows for both Smith and Smithfield should be included in the listing. Sort the results by employee number. Assume case sensitivity.

Write the SQL code to insert a new record to employee table: employee number: 119; last name: Wellman; first name: Bill; Middle Initial: K; employee hire date: 1996-02-12; Job Code: 501; emp years: 8

Write the SQL code to update the newly added employee Bill Wellmans Job Code to 506.

Write the SQL code to remove the newly added employee Bill Wellman.

Write the SQL code that will produce the same information that was shown in Problem 6 but sorted by the employees last name.

Write the SQL code that will list only the distinct project numbers in the ASSIGNMENT table, sorted by project number.