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 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
Get step-by-step solutions from verified subject matter experts
