Please help to write an SQL statement to show first and last names of female employees. The title of female employee is either Mrs. or Ms. And please sort the output in ascending order of employee last name. Thank you very much.

CREATE TABLE EMPLOYEE EMP_NUM NUMBER PRIMARY KEY, EMP TITLE CHAR(10), EMP_LNAME VARCHAR(15) NOT NULL, EMP_FNAME VARCHAR(15) NOT NULL, EMP_INITIAL CHAR(1) EMP_DOB EMP_HIRE_DATE DATE, EMP_YEARS NUMBER, EMP_AREACODE CHAR(3), EMP_PHONE CHAR(8)): DATE, CREATE TABLE EMP ( EMP_NUM NUMBER PRIMARY KEY, EMP TITLE CHAR(10), EMP_LNAME VARCHAR(15) NOT NULL, EMP_FNAME VARCHAR(15) NOT NULL, EMP_INITIAL CHAR(1) EMP_DOB EMP_HIRE_DATE DATE, EMP_AREACODE CHAR(3), EMP_PHONE CHAR(8), EMP_MGRNUMBER): DATE