SHOW ME THE  hire date OF THE EMPLOYEE WHO HAS THE FIRST NAME AS JAMES
SELECT EMP_HIREDATE FROM EMPLOYEE WHERE EMP_FNAME  =  "James"
hire date refers to EMP_HIREDATE; first name as James refers to EMP_FNAME = 'James';