Consider the following table: Emp_id Emp_name Job_name Manager_id Hire_date Salary 68319 66928 67832 64989 66564 KAYLING...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the following table: Emp_id Emp_name Job_name Manager_id Hire_date Salary 68319 66928 67832 64989 66564 KAYLING BLAZE CLARE ADELYN MADDEN PRESIDENT MANAGER ANALYST ANALYST SALESMAN 68319 65646 66928 66928 1991-11-18 6000.00 1991-05-01 2750.00 1997-04-19 3100.00 Commission Dep_id 1991-02-20 1700.00 400.00 1500.00 1991-09-28 1350.00 1001 3001 h. Write a query in SQL to list all the employees whose designation is CLERK i. Write a query in SQL to list the employees whose salaries are less than 3500 2001 3001 3001 Answer the following Queries a. Write a query in SQL to find the salaries of all employees b. Write a query in SQL to list the employees who does not belong to department 2001. c. Write a query in SQL to list the emp_id, salary, and commission of all the employees. d. Write a query in SQL to list the employees who joined before 1991 e. Write a query in SQL to display the average salaries of all the employees who works as ANALYST. f. Write a query in SQL to display the details of the employee BLAZE g. Write a query in SQL to display all the details of the employees whose commission is more than their salary. Consider the following table: Emp_id Emp_name Job_name Manager_id Hire_date Salary 68319 66928 67832 64989 66564 KAYLING BLAZE CLARE ADELYN MADDEN PRESIDENT MANAGER ANALYST ANALYST SALESMAN 68319 65646 66928 66928 1991-11-18 6000.00 1991-05-01 2750.00 1997-04-19 3100.00 Commission Dep_id 1991-02-20 1700.00 400.00 1500.00 1991-09-28 1350.00 1001 3001 h. Write a query in SQL to list all the employees whose designation is CLERK i. Write a query in SQL to list the employees whose salaries are less than 3500 2001 3001 3001 Answer the following Queries a. Write a query in SQL to find the salaries of all employees b. Write a query in SQL to list the employees who does not belong to department 2001. c. Write a query in SQL to list the emp_id, salary, and commission of all the employees. d. Write a query in SQL to list the employees who joined before 1991 e. Write a query in SQL to display the average salaries of all the employees who works as ANALYST. f. Write a query in SQL to display the details of the employee BLAZE g. Write a query in SQL to display all the details of the employees whose commission is more than their salary.
Expert Answer:
Related Book For
Accounting for Decision Making and Control
ISBN: 978-0078025747
8th edition
Authors: Jerold Zimmerman
Posted Date:
Students also viewed these databases questions
-
What insights can be gained from comparative genomics studies across species, shedding light on evolutionary relationships, genome evolution, and the functional significance of conserved sequences?
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Mr. Ahmed, an Omani, was relocated to work as a department manager at a leading drug company in the US. This relocation of work has caused a lot of anxiety on the part of Ahmed because it will be his...
-
Unlike other sciences, the nature and value of philosophy is derived from reflection versus testing, measuring, or examining. O True O False 4
-
How difficult has it been for Amazon to keep pace with customer expectations? Based on how the company originated, do you think Amazon was positioned well for its development into the variety of...
-
A balanced Y-connected load, with impedances 65.020 , is connected to a three-phase, three-wire, CBA system, where V AB = 678.8 120 V. Obtain the three line currents.
-
Rationalize the denominator of \(\frac{15}{5-\sqrt{13}}\).
-
Yard Tools manufactures lawnmowers, weed-trimmers, and chainsaws. Its sales mix and contribution margin per unit are as follows. Yard Tools has fixed costs of $4,200,000. Instructions Compute the...
-
Real Estate Broker. 88. sales associate affiliated with broker and negotiated a lease of owners property to client. owner paid a commission to sales associate in accordance with sales associates...
-
1. The model should list the given financial information for all potential projects. 2. The model should associate with each proposed project a cell that is 1 if the project is approved and 0 if it...
-
Allison's is expected to have annual free cash flow of $ 7 3 , 6 0 0 , $ 7 9 , 9 0 0 , and $ 8 6 , 3 0 0 for the next three years, respectively. After that, the free cash flow is expected to increase...
-
Although professional guidance is provided to assist CPAs in making judgments about the appropriate response to individual situations, many situations tend to be in a gray area. Following are some...
-
Review the Dysfunctions of Organizational Communication section. Have you experienced any of those dysfunctions during your college education? Reflect on your work experiences. Discuss examples of...
-
If the product is right and the sales presentation is right, there is no need to close the sale. Discuss.
-
In the early 1990s, KPMG established a separate company named KPMG Baymark as an investment banking unit to secure millions of dollars in deal fees otherwise beyond the grasp of the firm when it acts...
-
Review the decision-making models described in this chapter. Which model do you think is closest to what managers do when they make decisions? Why?
-
. German Volume Training stimulates a natural growth hormone response to training because of
-
What are some of the various ways to implement an awareness program?
-
Wyatts Channelview refinery can distill 60 million barrels of oil per year and feed 30 million barrels of heavy distillate a year into the cat cracker. It can process either light, sweet crude from...
-
Joon manufactures and sells to retailers a variety of home care and personal care products. Joon has a single plant that produces all four of its product lines: Stick Goods (brooms and mops), Floor...
-
Employee bonuses at American InterConnect (AI), a large communications firm, depend on meeting a number of targets, one of which is a revenue target. Some bonus is awarded to the group if it meets or...
-
The chief accountant of Uncertain Ltd is not sure of the appropriate accounting treatment for a number of events occurring during the year 2005/6. (i) A significant number of employees have been made...
-
Identify which of the following numbers are irrational: \(\sqrt{441}, 4.33, \sqrt{70}, 5+9 \pi\)
-
\(\sqrt{75}\) Simplify the square root by expressing it in lowest terms.
Study smarter with the SolutionInn App