Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write a query to get the average salaries of jobs grouped by their department number. List all employees in the Sales, and Operations departments using
- Write a query to get the average salaries of jobs grouped by their department number.
- List all employees in the Sales, and Operations departments using subquery.
- Write a query to get the maximum salaries of each department using department numbers where the minimum salary is greater than 100.
- Write a query to show the employees whose departments are in New York city. Display only the data from the employee table. (use sub query)
- Write a query that displays the name of the Department where the average salary is maximum. (use sub query)
- Write a query to display all department numbers where the minimum salary is greater than the minimum salary of department number 30 .
IN SQL
Do these tasks in as simple way as possible and if all tasks done correctly i will surely give thumbs up. TABLE NAME IS TABLE 1 ..2 AND SO ON
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