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. SELECT FROM WHERE ORDER BY EMP_NUM, EMP_LNAME, EMP_FNAME, EMP_INITIAL EMPLOYEE EMP_LNAME LIKE 'Smith%' EMP_NUM;