LISTING 1: WHERE Clause with Two Predicates

SELECT emp_fname, emp_lname
    FROM employee
    WHERE dept_no = 'd1'
    AND enter_date BETWEEN '1.1.1998' AND '12.31.1998'