SQL Query to find Employees with Similar LastName 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