List the employees who have salary between 1000&2000. EMPNO ENAME 7369 SMITH 7499 ALLEN 7521 WARD 7566
Fantastic news! We've Found the answer you've been seeking!
Question:
- List the employees who have salary between 1000&2000.
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
Fundamentals of Database Systems
ISBN: 978-0136086208
6th edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date:
Students also viewed these databases questions
-
List the employees who have salary between 1000&2000 (using AND Operator) EMPNO ENAME 7369 SMITH 7499 ALLEN 7521 WARD 7566 JONES 7654 MARTIN 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 KING 7844 TURNER...
-
List all employees who are not managers and are paid more than $1500.
-
Employees who have a union are better off than those who dont.
-
Implement the method contains() for BST.
-
In Wayne Company, materials are entered at the beginning of each process. Work in process inventories, with the percentage of work done on conversion costs, and production data for its Sterilizing...
-
(a) Calculate the marginal frequencies and (b) Find the expected frequency for each cell in the contingency table. Assume that the variables are independent. Age Type of movie rented 45-64 65 and...
-
The following sale related transactions for Beautiful Decor, Inc., occurred during the month of April. Requirement 1. Journalize the transactions for Beautiful Decor, Inc. Omit explanations. Apr 3...
-
Unter Components manufactures low-cost navigation systems for installation in ride-sharing cars. It sells these systems to various car services that can customize them for their locale and business...
-
Working required Unanswered Question 8 Correct Answer 0/200 pts Let f (x) be a function defined for all real numbers, such that f(3x-9) = f(x) for all R. If f(x) 5x2 +7 lim x2 = 20 2-x find (if it...
-
A hollow, circular, cast-iron pipe (Ec = 12,000 ksi) supports a brass rod (Eb 14,000 ksi) and weight W = 2 kips, as shown. The outside diameter of the pipe is dc = 6 in. (a) If the allowable...
-
You have found that you need to have a total of $1,529,499 in savings at the time you retire, in 40 years. You currently only have $28,118 saved up in your retirement accounts. If you anticipate that...
-
Recall a social or work-related situation when you felt conversationally challenged. Describe how you could have used the guidelines in this chapter to engage more competently. a. If appropriate,...
-
Mental health experts generally find it is better to have others disagree with you than ignore you. With a partner or group of classmates, recall specific examples from personal experiences to...
-
Identify the ongoing narratives in either your current family or your family of origin. Explain: a. The narrative b. When and how it is retold c. The way this narrative portrays your family d. The...
-
Consider how you manage boundaries with members of your family (immediate or extended). See if you can identify familial relationships in your life that are typified by each of these four patterns...
-
Gibb argues that spontaneous rather than strategic communication reduces defensiveness. However, in some situations a strategic approach may hold the promise of a better climate than a completely...
-
Can someone please help me with sections d, e, and f? Black and Shannon trave decided to fom a partnership. They have agreed that Black is to invest \( \$ 243,000 \) and that 5 hannon is to invest...
-
10m solution. If Ka(HA) = 10 then pOH of solution will be [Given : log4=0.6] (A) 6.7 (B) Greater than 6.7 & less than 7.0 (C) Greater 7.0 & less than 7.3 (D) Greater than 7.3
-
Specify the updates of Exercise 3.11 using the SQL update commands. In exercise 3.11 (a) Insert < 'Robert', 'F', 'Scott', '943775543', '21-JUN-42', '2365 Newcastle Rd, Bellaire, TX', M, 58000,...
-
Consider the following relation: CAR_SALE(Car#, Date_sold, Salesman#, Commision%, Discount_amt Assume that a car may be sold by multiple salesmen and hence {CAR#, SALESMAN#} is the primary key....
-
How many serial schedules exist for the three transactions in Figure 21.8 (a)? What are they? What is the total number of possible schedules?
-
What is the general reporting format on financial statements prepared in accordance with a comprehensive basis of accounting other than generally accepted accounting principles?
-
What is negative assurance within the context of an auditor's report? How does it differ from positive assurance?
-
What body establishes standards for a. All audits and for reviews of interim financial information and preparation of unaudited financial statements of public companies? b. Reviews and compilations...
Study smarter with the SolutionInn App