I have existing answers dont copy
surely dislike answer only u know
Extracted text: (Consider table employees with the following colunms (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID) (Consider table jobs with the following colunms (JOB_ID,JOB_TITLE,MIN_SALARY, MAX_SALARY) „PHONE_NUMBER HIRE DATE , JOB_ID SALARY which query is the most appropriate to display employee id, first name and salary in hundreds for all employees whose job title is "Accountant"? * select employee_id, first_name, round(salary,-2) from employees where job_id in (select job_id from jobs where lower(job_title) = 'Accountant'); select employee_id, first_name, round(salary,-2) from employees where job_id in (select job_id from jobs where lower(job title) = 'accountant): select employee_id, first_name, round(salary,-2) from employees where job_id = (select job_id from jobs where lowerljob_title) = 'Accountant); sélect employee_id, first_name, round(salary,-2) from employees where job_id = (select job_id from jobs where lower(job_title) = 'accountant'):