Display the information about the managers and clerks from the column Job in the table emp, order
Fantastic news! We've Found the answer you've been seeking!
Question:
- Display the information about the managers and clerks from the column ‘Job’ in the table emp, order the result by deptno.
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
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
The clerks at Raley's were represented by the Independent Drug Clerks Association (IDCA). When the Retail Clerks Union (Retail Clerks) began a campaign to oust IDCA, Raley's maintained a neutral...
-
The spreadsheet provides information about the economy in Argentina. Column A is the year, Column B is real GDP in billions of 2000 pesos, and Column C is the price level. a. In which years did...
-
In order to gain additional information about respondents, some marketing researchers have used ultraviolet ink to precode questionnaires that promise confidentiality to respondents. Of 205 randomly...
-
Consider a symmetric oligopoly in which firms technologies satisfy assumption 5.1. Assume that firms get part of the tax revenues refunded, according to their market shares. The refund share is 0 A...
-
The Standish Group published their Extreme Chaos report and quoted a high rate of IT project failure. How did they define failure? Do you agree with their definition? Is on budget a reliable metric...
-
Match the regression equation with the appropriate graph. y = 2.115x + 21.958 b. a. 30 25 25 20 20 15 15 10 10 5+ 5 10 15 20 25 30 35 40 4 6. 10 d. y C. 140 70 120 60 100 50 80 40 60 30 40 20 20 10...
-
The following transactions occurred during April 2010, for Sandy Salon Products, Inc.: Requirement 1. Journalize the April transactions for Sandy Salon Products, Inc. Omit explanations. Apr 3...
-
Laser Impression, Inc., manufactures color laser. Model J20 presently sells for $360 and loss a total product cost of $288, as follows: Direct material ........ $218 Direct labor ......... 50 Factory...
-
8. (8 points) a. Explain why 0 x tanx < -1 . for all 0 < x < 1. 4 Use the properties of the integrals to show that the value of the integral x tanx dx lies on the interval [0, 17]. Bonus: (6 points)...
-
A heat engine running backward is called a refrigerator if its purpose is to extract heat from a cold reservoir. The same engine running backward is called a heat pump if its purpose is to exhaust...
-
You have been approached to give some new graduate trainees a talk. Prepare and shed light on the following human resource management concepts; a) Outsourcing b) Hard and Soft Human Resource c)...
-
An advantage of using the direct approach with negative messages is that it a. saves readers time by helping them reach the main idea more quickly. b. eases readers into the message. c. is...
-
What are the disadvantages in a situation where an organization chooses to share negative information at the very last moment possible?
-
Determine whether the following sentences focus on selling points or benefits; rewrite as necessary to focus all the sentences on benefits. a. This model has heated front seats in black Nappa...
-
Having suffered from a life-threatening illness for some time, you have undergone ground-breaking surgery and have been cured. You know that you are very lucky because this technique has not been...
-
How does the social communication model differ from traditional business communication practices?
-
After the Second World War, the global society is becoming increasingly interconnected. One important factor responsible for this phenomenon is the increasing number of international non-governmental...
-
The vapor pressure of the liquid NH, is measured at different temperatures. The following vapor pressure data are obtained. Temperature, K P, mmHg 217.1 223.4 234.7 588.1 Calculate the enthalpy of...
-
Matthew borrows $250,000 to invest in bonds. During 2012, his interest on the loan is $30,000. Matthew's interest income from the bonds is $10,000. This is Matthew's only investment income. a....
-
In 2012, Lou has a salary of $54,000 from her job. She also has interest income of $1,700. Lou is single and has no dependents. During the year, Lou sold silver coins held as an investment for a...
-
How much of each of the following prizes or awards is taxable? a. Cheline received a $50,000 gift bag at the Oscars in 2012. b. Jon received a gold watch worth $350 for 25 years of service to his...
-
A sample of adults was asked whether they were interested in economic issues. The following MINITAB output presents the results of a hypothesis test regarding the proportion who said they were...
-
A few weeks before election day, a TV station broadcast a debate between the two leading candidates for governor. Viewers were invited to send a tweet to indicate which candidate they plan to vote...
-
A simple random sample of 500 students at a certain college were surveyed and asked whether they were satisfied with college life. Two hundred eighty of them replied that they were satisfied. The...
Study smarter with the SolutionInn App