Display employees names, salary, and manager values of those employees whose salary is 5000 from EMP table
Fantastic news! We've Found the answer you've been seeking!
Question:
- Display employees’ names, salary, and manager values of those employees whose salary is 5000 from EMP table using SELECT statement.
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
Government and Not for Profit Accounting Concepts and Practices
ISBN: 978-1118155974
6th edition
Authors: Michael H. Granof, Saleha B. Khumawala
Posted Date:
Students also viewed these databases questions
-
Select three table values from Table 14 - 1 and verify them using the formula FV = (1+ R}N 1 R
-
Select three table values from Table 14-2 and verify them using the formula TV = R / (1 + R) N - 1
-
Select three table values from Table 14 - 3 and verify them using the formula TV = (1 + R) N - 1 / R(1 + R) N
-
Integer sort. Write a linear-time filter that reads from standard input a sequence of integers that are between 0 and 99 and prints to standard output the same integers in sorted order. For example,...
-
Is there an optimal solution to a GP or MOLP problem? Explain.
-
A financial analyst claims that the distribution of people who use cash to make their purchases is different from the distribution shown in the figure. You randomly select 600 people and record the...
-
The adjusted trial balance for CED Electric, Inc., as of June 30, 2010, is presented next: Requirements 1. Prepare the multi-step income statement for June for CED Electric, Inc. 2. Calculate the...
-
Willard Company manufactures three different sizes of automobile sunscreens: large, medium, and small. Willard expects to incur $360,000 of overhead costs during the next fiscal year. Other budget...
-
Mth 234 I < > Upcoming Eve... K Candidate Prof... mylab.pearson.com State Farm Tal... I Job Board - Re... G the average m... I Grades for Sofi... I MATH 234 All... Do Homework... G The average m......
-
Glen Pool Club, Inc., has an installment loan outstanding with a current balance of $150.000. The company makes monthly installments of $1,543, which include interest computed at an annual rate of 6...
-
Which of the following is NOT an indicator that adolescents can be considered herd animals? a) They prefer social media photos that have received many likes. b) They tend to talk more like their...
-
Why is paying attention to an interviewers verbal and nonverbal cues as important as responding to questions?
-
Discuss why it could be useful to look for stepping-stone opportunities alongside specific job positions. Explain your answer.
-
How can design consistency be useful in the setting of presentations of company products and branding to customers?
-
Assume you are a news anchor for a television channel presenting election results from different states or districts as well as tweets from your viewers. Would a linear or a nonlinear presentation be...
-
Students may well be asked to discuss their leisure pursuits during selection processes. Your task: Prepare a brief presentation about one of your leisure pursuits. Your purpose should be to...
-
Doug, Peter, and Jack have the following capital balances;$150,000, $300,000 and $320,000, respectively. The partners shareprofits and losses 35%, 40%, and 25% respectively. Jones is goingto pay a 2...
-
From the choice of simple moving average, exponential smoothing, and linear regression analysis, which forecasting technique would you consider the most accurate? Why? please write it in word...
-
The schedule that follows pertaining to governmental capital assets was excerpted from the annual report of Urbana, Illinois (with changed dates): A related schedule indicates the following: Capital...
-
What are the two main components of a single audit?
-
A not-for-prot organization has an endowment fund that, at the start of the year, has a value of $1 millionthe amount initially contributed to establish the fund. Owing to investment losses, the...
-
On July 31, 2020, Magnus's Muffins paid \(\$ 18,000\) for business insurance for the next year. Record the entries for the purchase of the insurance by recording it as an expense and then making a...
-
On November 1, 2020, Freya Albatter's orthodontic office received a \(\$ 2,500\) prepayment from a client for dental work to be performed on November 22. The appointment got postponed until January...
-
On April 1, 2020, you prepaid three months of rent for a total of \(\$ 18,000\). Give your adjusting entry to record rent expense at April 30, 2020. Include the date of the entry and an explanation....
Study smarter with the SolutionInn App