(Consider table employees with the following colunms (EMPLOYEE_ID, FIRST NAME, LAST_NAME , EMAIL ,PHONE_NUMBER ,COMMISSION_PCT, MANAGER ID, DEPARTMENT_ID) (Consider table jobs with the following colunms (JOB_ID,JOB_TITLE,MIN SALARY,MAX_SALARY) 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 lower(job 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'):
(Consider table employees with the following colunms (EMPLOYEE_ID, FIRST NAME, LAST_NAME , EMAIL ,PHONE_NUMBER ,COMMISSION_PCT, MANAGER ID, DEPARTMENT_ID) (Consider table jobs with the following colunms (JOB_ID,JOB_TITLE,MIN SALARY,MAX_SALARY) 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 lower(job 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'):
Chapter11: Group Functions
Section: Chapter Questions
Problem 1RQ
Related questions
Question
I have existing answers dont copy
surely dislike answer only u know
Transcribed Image 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'):
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
C++ for Engineers and Scientists
Computer Science
ISBN:
9781133187844
Author:
Bronson, Gary J.
Publisher:
Course Technology Ptr
C++ for Engineers and Scientists
Computer Science
ISBN:
9781133187844
Author:
Bronson, Gary J.
Publisher:
Course Technology Ptr