Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

10. Write a query to display the employees of Deptno 20 or 10 joined in the year 1981. 11. Write a query to display the

image text in transcribed
10. Write a query to display the employees of Deptno 20 or 10 joined in the year 1981. 11. Write a query to display the employees number, name, salary, department name of all the 'MANAGERS' and 'CLERKS' working in New York, Dallas with an experiences more than 40 years without receiving the comm. Sort them as ascending of location. 12. Write a query to display the employees whose Jobs are same as Smith. 13. Write a query to display the employees of Deptno 10 whose jobs are same as Deptno 20. 14. Write a query to display the employees whose salary is same as MILLER or ALLEN, sort it based on salary in descending order. 15. Write a query to display any jobs of deptno 10 , those that are not found in deptno 20. 16. Write a query to find the highest paid employee of sales department. 17. Write a query to find the total salary given to the Manager. 18. Write a query to display all managers no and the number of employees working for those managers. Sort them as ascending of manager number. 19. Write a query to display the department details where at least two employees are working in the department. 20. Write a query to display the employees name, job, department name, location for those who are working as managers. 21. Write a query to display the employees name, salary, commission. For those employees whose net pay is greater than or equal to any other employee salary of the company. 22. Write a query to display the name of department where highest number of employees are working. 23. Write a query to find out how many Managers are their in the company. 24. Write a query to display the employees name, Job, Annual Salary, department no, department name and grade who earn more than 30000 a year or who are not CLERKS. 25. Write a query to display the employees details for whose grade are greater than the grade of MILLER

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing

Authors: David M. Kroenke

12th Edition International Edition

1292023422, 978-1292023427

More Books

Students also viewed these Databases questions

Question

=+ Who are the buyers/users of the products abroad?

Answered: 1 week ago