Question: IN SQL 1 (Consider table employees with the following colunms (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL PHONE_NUMBER , HIRE_DATE , JOB_ID SALARY ,COMMISSION_PCT, MANAGER_ID , DEPARTMENT_ID) (Consider
IN SQL
1 (Consider table employees with the following colunms (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL PHONE_NUMBER , HIRE_DATE , JOB_ID SALARY ,COMMISSION_PCT, MANAGER_ID , DEPARTMENT_ID) (Consider table jobs with the following colunms (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_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"? * (5) (2 Points) 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 lower(job_title) = 'accountant'); select employee_id, first_name, round(salary,-2) from employees where job_id = (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')
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
