please show me the DOB OF EMPLOYEE WHO HAS THIS AS HIS FIRST NAME | Do you mean the first name "James"? | yeah
SELECT EMP_DOB FROM EMPLOYEE WHERE EMP_FNAME  =  "James"
DOB of employee refers to EMP_DOB; first name specified as 'James' refers to EMP_FNAME = 'James';