Find the empno, job, and hire date of all Clerks and managers hired before 1990. (do not
Fantastic news! We've Found the answer you've been seeking!
Question:
Find the empno, job, and hire date of all Clerks and managers hired before 1990. (do not use IN)
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
-
Find the empno, job, and hire date of all Clerks and managers hired before 1990. (use IN) EMPNO ENAME 7369 SMITH 7499 ALLEN 7521 WARD 7566 JONES 7654 MARTIN 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 KING...
-
Managers in some companies claim that they do not use flexible budgeting, yet they compute a sales volume variance. How is that different from flexible budgeting?
-
Do you think that most managers in real life use a contingency approach to increase their leadership effectiveness? Discuss.
-
Consider a situation with two countries that have abatement cost functions : for j=L and j=H. The countries have identical damage functions D(E)= d.E.For each country the parameters s j are drawn...
-
Describe the fixed cost, variable cost, break-even point
-
You have been made treasurer for a day at AIMCO, which develops technology for video conferencing. A manager of the satellite division has asked you to authorize a capital expenditure in the amount...
-
Allied Electronics in Exhibit 14-8, page 704, is most likely to earn net income of \(\$ x\) next year. How much is \(\$ x\) ? a. \(\$ 90,000\) b. \(\$ 79,000\) c. \(\$ 75,000\) d. \(\$ 54,000\)
-
Campbell Corporation reports regular taxable income of $210,000 in the current year. Campbell takes into account the following facts when calculating the $210,000 amount. Campbell deducts $100,000...
-
What recommendations would you give to Zynga' top management that would allow the company to regain and sustain competitive advantage in the industry?
-
Background: SO MUCH CANDY DATA, SERIOUSLYCandy hierarchy data for 2017 Boing Boing Halloween candy hierarchy. This is survey data over the span of 4-years. The data is split into 4 separate files....
-
O'Brien Company manufactures and sells one product. The following information pertains to each of the company's first three years of operations: Variable costs per unit: Manufacturing: Direct...
-
Write an algorithm and C code for deleting any node from the singly linear linked list.
-
How will you represent a linear and circular linked list in a graphical view?
-
What is the state of the stack after the following sequence of pushes and pops? Stack s; 3 ); s.push( s.push ( 5 ); 2); 15 ); 42 ) ; s.push( s.push( s.push( s.pop (); s.pop (); s.push ( 14 ); s.push...
-
What would improve the way disagreements or complaints are handled?
-
Write C code for displaying all data members of singly linear linked list in reverse manner.
-
The AveiroTech, Inc. is a holding company. Today, AveiroTech is studying a takeover bid on SvalbardTech, a biotech company. The takeover requires an initial investment of 3.5 million euros and has an...
-
The Pletcher Transportation Company uses a responsibility reporting system to measure the performance of its three investment centers: Planes, Taxis, and Limos. Segment performance is measured using...
-
A fire destroyed certain accounting records of Green Books. The controller, Marilyn Green, asks your help in reconstructing the records. All of the sales are on account, with credit terms of 2/10,...
-
What does the gross profit percentage measure and how is it calculated?
-
XM, Ltd. was a small engineering firm that built high-tech robotic devices for electronics manufacturers. One very complex device was partially completed at the end of 2018. Barb McLauren, head...
-
What are the major elements of risk assessment?
-
How does an organization go about identifying, measuring, and prioritizing risks? Who is responsible for the assessment of risk in an organization?
-
What is risk? How does management generally perceive the dimensions of risk?
Study smarter with the SolutionInn App