List the name and empno of managers who earn more than 2000.display the result in alphabetical order
Fantastic news! We've Found the answer you've been seeking!
Question:
- List the name and empno of managers who earn more than 2000.display the result in alphabetical order of the name.
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 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 800 1600 1250 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 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 800 1600 1250 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
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these databases questions
-
In alphabetical order below are balance sheet items for Burnett Company at December 31, 2014. Prepare a balance sheet following the format of Illustration 1-7 Accounts payable ...... $65,000 Accounts...
-
List all employees who are not managers and are paid more than $1500.
-
In alphabetical order below are balance sheet items for Lopez Company at December 31, 2010. Kim Lopez is the owner of Lopez Company. Prepare a balance sheet, following the format of Illustration 1-9....
-
Write a program that takes a start string and a stop string as commandline arguments and prints all substrings of a given string that start with the first, end with the second, and otherwise contain...
-
Osage Corporation issued $600,000, 7%, 10-year bonds on January 1, 2010, for $559,740. This price resulted in an effective-interest rate of 8% on the bonds. Interest is payable annually on January 1....
-
List five important differences between producing goods and performing services.
-
P Ltd bought 40,000 shares in \($1\) Ltd and 27,000 shares in \($2\) Ltd on 31 December 2002. The following balance sheets were drafted as at 31 December 2003. You are to draw up a consolidated...
-
Autotech Manufacturing is engaged in the production of replacement parts for automobiles. One plant specializes in the production of two parts: Part 127 and Part 234. Part 127 produced the highest...
-
plslsss help 8. William need to save money for college. There are two options for him: Option 1: Invest $5000 into an account that pays 7.75% compounded weekly for 10 years Option 2: Make regular...
-
create a Marketing 2033; In class Interview /Brand Presentation (15%) Goal : To bring together PMP development in one final verbal and visual presentation. Assignment : In a mock interview (I will be...
-
Compare the similarities and differences between MIS, DSS, TPS, and ESS systems.
-
Crane produces two joint products, Coconut Milk and Coconut Meat. The company uses the leftover Coconut Skin as a by-product. All three are produced from joint costs of $81500: direct materials...
-
"Financial advisor Suze Orman says one thing about housing while Warren Buffett (the Oracle of Omaha) says another. Which one do you agree with ... AND WHY??
-
Given the weighted quadratic loss function L(0, d) = w(0) (0 d) with w(0)> 0 for all 0 = R. Determine dmin such that the posterior risk is minimized and interpret the solution. Hint: The order of...
-
Joanette, Incorporated, is considering the purchase of a machine that would cost $670,000 and would last for 10 years, at the end of which, the machine would have a salvage value of $57,000. The...
-
explain how to win the game as well as the questions listed below on the difference in leaders. For example, if it was easier for the Israel leader to secure peace? What was the impact of the level...
-
Can i get help with a research paper. I have attached the proposal. ECE 124 Child Development: 2 to 6 years Research Assignment Part One Group Presentation Proposal: 5% Due date: February 8, 2024...
-
Anna, a high school counselor, devised a program that integrates classroom learning with vocational training to help adolescents at risk for school dropouts stay in school and transition to work...
-
What are the characteristics of OLTP systems?
-
Describe the purpose of the JOIN command in relational algebra.
-
In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1. (If you use a computer to complete these exercises, use a copy of the TAL Distributors database...
-
Question: Marvin asks Sheila, a qualified auto mechanic, to fix his engine, which constantly stalls (stops) while driving. When Marvin returns, Sheila informs him that the engine is now "Perfect-runs...
-
2. Joya is the head of the personal insurance division of a large insurance company. Six months before, she was almost promoted to vice-president, but she lost out to Bill, a colleague from another...
-
4. Mark is an executive for a multinational office equipment company that would like to enter the potentially vast Chinese market. The official tariffs on office equipment imported into China are so...
Study smarter with the SolutionInn App