Chapter 11, Problem 2P

Problem 1 and 2 are based on the following query:

SELECT	EMP_LNAME, EMP_FNAME, EMP_AREACODE, EMP_SEX
FROM	EMPLOYEE
WHERE	EMP_SEX = 'F' AND EMP_AREACODE = '615'
ORDER BY	EMP_LNAME, EMP_FNAME;

What indexes should you create? Write the required SQL commands.