Question
Write an SQL for the following problem and take a screen shot of the output Task 3: Group Function and Group Rows 1) Display how
Write an SQL for the following problem and take a screen shot of the output
Task 3: Group Function and Group Rows
1) Display how many employees with a salary that is less than 6000 in each job id, in each department.
2) Display the average, maximum, and minimum salary of all employees under a manager with ID 110 or 150
3)Display the last name, first name, department, and city of all employees working with the manager of the department with id number 103 or 205.
4) Count how many employees working in each country per department. Display only with number of employees of more than 20.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started