Question: please answer quick using hr.employees from oracle live sql 1. Write a query to display the name ( first name and last name ) for

please answer quick

using hr.employees from oracle live sql

1. Write a query to display the name ( first name and last name ) for those employees who gets more salary than the employee whose ID is 100.

Sample table: hr.employees

2. Write a query to display the name ( first name and last name ), salary, department id, job id for those employees who works in the same designation as the employee works whose id is 161.

Sample table: hr.employees

3. Write a query to display the name (first name and last name ), salary, department id for those employees who earn such amount of salary which is the smallest salary of any of the departments.

Sample table: hr.employees

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!