Write a query to return all employees still working for the company with last names starting with "Smith" sorted by last name then first name. code example
Example: 2. Design a query that displays the SSN, Last Name, First Name and the department name of female employees
2. Design a query that displays the SSN, Last Name, First Name and the department name of female employees