Question: write an SQL command 1. Display last name, first name, salary and department name of all mployees whose location is at 1800 2. Display last

 write an SQL command 1. Display last name, first name, salary

write an SQL command

1. Display last name, first name, salary and department name of all mployees whose location is at 1800 2. Display last name,first name, salary, job title of all employees under the department with ID 20 3. Display last name, first name, department, city of all employees working with manager of the department with id number 200 Display last name, first name, department name, city and country of all employees with a salary more than 6000. 5. Count how many employees working in each country per department. Display only with number of employees of more than 10 040018

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!