Reference no: EM1337651
Question 1: Write a query to display the last name, department number, and salary of any employee whose department number and salary both match the department number and salary of any employee who earns a commission.
Question 2: Display the last name, department name, and salary of any employee whose salary and commission match the salary and commission of any employee located in location ID 1700.
Question 3: Create a query to display the last name, hire date, and salary for all employees who have the same salary and commission as Kochhar.
Note: Do not display Kochhar in the result set
Question 4: Create a query to display the employees who earn a salary that is higher than the salary of all of the sales managers (JOB_ID = 'SA_MAN'). Sort the results on salary from highest to lowest.
Question 5: Display the details of the employee ID, last name, and department ID of those employees who live in cities whose name begins with T.
Question 6: Write a query to find all employees who earn more than the average salary in their departments.Display last name, salary, department ID, and the average salary for the department. Sort by average salary. Use aliases for the columns retrieved by the query as shown in the sample output.
Attachment:- Week9_Assignment.pdf
|
Each station outputs an 80 bytes frame and buffers
: A group of stations share a 16 kbps slotted Aloha channel. Each station outputs a 80 Bytes frame and buffers any outgoing frames until they can be sent.
|
|
Estimation of company cost of capital
: Discuss how to and then perform a quantitative analysis and subsequently recommend the optimal capital structure mix for Berkshire Hathaway Inc. based on a 20 percent increase in assets.
|
|
Management''s role in the system development life cycle
: Discuss and explain the management's role in the system development life cycle.
|
|
Explain consumers on the internet
: Explain Consumers on the Internet and Research has shown that many consumers use the Internet to investigate purchases before actually buying
|
|
Write sql queries
: Write a query to display the last name, department number, and salary of any employee whose department number and salary both match the department number and salary of any employee who earns a commission.
|
|
Design a set of powerpoint slides explaining
: Jim and Tim are brothers who have a love of robots. They started a home based business known as 'RoboBoys' where they custom build robots for fun, gifts, competition and decoration.
|
|
Impact of risk on a project
: Explain how risk has impacted a project that you have been associated with as a team member or project leader.
|
|
How to open microsoft word and paste the information
: In this assignment, you will find out and critique virtual information and word processing skills to make a professional-looking document that promotes personal development or financial growth and maturity.
|
|
The term metrics
: Understanding the term metrics.
|