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...

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. display the attributes shown in the results presented in figure p7.1.