List the name, salary, commission of the employees where commission is greater than their salary. EMPNO ENAME
Fantastic news! We've Found the answer you've been seeking!
Question:
- List the name, salary, commission of the employees where commission is greater than their salary.
Transcribed Image Text:
EMPNO ENAME 7369 SMITH 7499 ALLEN 7521 WARD 7566 JONES 7654 MARTIN 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 KING 7844 TURNER 7876 ADAMS 7900 JAMES 7902 FORD 7934 MILLER JOB CLERK SALESMAN SALESMAN MANAGER SALESMAN MANAGER MANAGER ANALYST PRESIDENT SALESMAN CLERK CLERK ANALYST CLERK MGR 7902 7698 7698 7839 7698 7839 7839 7566 7698 7788 7698 7566 7782 HIREDATE SAL 800 1600 1250 17-Dec-80 20-Feb-81 22-Feb-81 02-Apr-81 2975 28-Sep-81 1250 01-May-81 2850 09-Jun-81 09-Dec-82 17-Nov-81 08-Sep-81 12-Jan-83 03-Dec-81 03-Dec-81 23-Jan-82 2450 3000 5000 1500 1100 950 3000 1300 COMM 300 500 1400 0 DEPTNO 20 30 8888 30 20 30 30 10 20 10 30 20 30 20 10 EMPNO ENAME 7369 SMITH 7499 ALLEN 7521 WARD 7566 JONES 7654 MARTIN 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 KING 7844 TURNER 7876 ADAMS 7900 JAMES 7902 FORD 7934 MILLER JOB CLERK SALESMAN SALESMAN MANAGER SALESMAN MANAGER MANAGER ANALYST PRESIDENT SALESMAN CLERK CLERK ANALYST CLERK MGR 7902 7698 7698 7839 7698 7839 7839 7566 7698 7788 7698 7566 7782 HIREDATE SAL 800 1600 1250 17-Dec-80 20-Feb-81 22-Feb-81 02-Apr-81 2975 28-Sep-81 1250 01-May-81 2850 09-Jun-81 09-Dec-82 17-Nov-81 08-Sep-81 12-Jan-83 03-Dec-81 03-Dec-81 23-Jan-82 2450 3000 5000 1500 1100 950 3000 1300 COMM 300 500 1400 0 DEPTNO 20 30 8888 30 20 30 30 10 20 10 30 20 30 20 10
Expert Answer:
Related Book For
Horngrens Financial And Managerial Accounting The Financial Chapters
ISBN: 9780134486840
6th Edition
Authors: Tracie L. Miller Nobles, Brenda L. Mattison, Ella Mae Matsumura
Posted Date:
Students also viewed these databases questions
-
Which employees get salary less than 20,000 and commission greater than 100. EMPNO ENAME 7369 SMITH 7499 ALLEN 7521 WARD 7566 JONES 7654 MARTIN 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 KING 7844 TURNER...
-
The mix of salary and commission Belleville Fashions sells high-quality womens, mens, and childrens clothing. The store employs a sales staff of 11 full-time employees and 12 part-time employees....
-
Is pressure greater or less in regions where streamlines are crowded?
-
Modify HashST to use a resizing array so that the average length of the list associated with each hash value is between 1 and 8 .
-
Consider a $2,000 deposit earning 8 percent interest per year for five years. What is the future value, and how much total interest is earned on the original deposit vs. how much is interest earned...
-
Greenleaf Company acquired patent rights on January 6, 2009, for $300,000. The patent has a useful life equal to its legal life of 12 years. On January 3, 2012, Greenleaf successfully defended the...
-
What stakeholder affected by their behavior was Gilead weighting very lightly when it decided what to tell the FDA about the medicines it wished to have permission to sell?
-
Shao Airlines is considering two alternative planes. Plane A has an expected life of 5 years, will cost $100 million, and will produce net cash flows of $30 million per year. Plane B has a life of 10...
-
Discuss how a good understanding of the state of the economy might help you make better decisions. Discuss how much of a role you think a government should play in a market system. Explain how you...
-
Troys Tires sells a certain brand tire which has a daily demand that is normally distributed, with a mean of 15 tires and a standard deviation of 4 tires. (In your model use integers for all...
-
The cannon on a battleship can fire a shell a maximum distance of43.9km. (a)Calculate the initial velocity of the shell in meters per second. (Enter the magnitude.) m/s (b)What maximum height in...
-
Jane, Mark, and Guy are farmers who store their grain in three silos. Jane contributes half of the grain, Mark a third, and Guy a sixth. A tornado hits two of the silos and scatters the grain. If...
-
How can a bailor overcome a limit that a warehouse company places on its liability?
-
John is a cabinetmaker. Tammy contracts with John to make and install a custom bookcase in her house for $4,000. John completes the bookcase, but Tammy does not pay. To obtain the amount that is...
-
Julio and Gloria are officers of World Export Corporation. As corporate officers, their rights are set out in a. state corporation statutes. b. World Exports certificate of authority. c. their...
-
Inez files an employment discrimination suit against Jiffy Delivery Service, under Title VII of the Civil Rights Act, based on Jiffys discharge of Inez. If Inez prevails in her prima facie case, one...
-
Let f(x) = x 2x x-1 - 48 .Write the domain of f as an interval.
-
President Lee Coone has asked you to continue planning for an integrated corporate NDAS network. Ultimately, this network will link all the offices with the Tampa head office and become the...
-
Use the Target Corporation financial statements to answer the following questions. Visit http:// www.pearsonhighered. com /Horngren to view a link to Target Corporations Fiscal 2015 Annual Report....
-
Describe the similarities and differences among the four different types of business entities discussed in the chapter.
-
If a business had a net loss for the year, where would the net loss be reported on the worksheet?
-
Consider the homogeneous bar, of negligible cross section, mass \(M=1.333 \mathrm{~kg}\) and length \(L=60.0 \mathrm{~cm}\) in Fig.12.19 . It is constrained to rotate in a vertical plane about its...
-
A projectile of mass \(m=2.5 \mathrm{~kg}\) is shot tangentially (see Fig.12.19) at the edge of a ring having radius \(R=50 \mathrm{~cm}\) and whose mass is equal (within measurement errors) to that...
-
A homogeneous disk, having mass \(M=2.50 \mathrm{~kg}\) and radius \(R=15.0 \mathrm{~cm}\), can rotate, without friction, about a fixed horizontal axis, passing through the point \(\mathrm{O}\) of...
Study smarter with the SolutionInn App