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.
-
On October 1, 2009, Havenhill Corp. issued $700,000, 7%, 10-year bonds at face value. The bonds were dated October 1, 2009, and pay interest annually on October 1. Financial statements are prepared...
-
Discuss the phased approach used in the DM stage of Kimballs Business Dimensional Lifecycle.
-
You are to draw up a consolidated balance sheet as at 31 December 2005 from the following: At the balance sheet date, Son 1 owed Pa and Mum 2,500 and Son 2 1,100, and Pa and Mum owed Son 2 2,100. Pa...
-
The three accounts shown below appear in the general ledger of Bennis Corp. during 2011. Instructions From the postings in the accounts, indicate how the information is reported on a statement of...
-
Ex6 : A stock is expected to pay a dividend of $1 per share every quarter. The stock price is $50 and the risk free rate is 5% per annum. An investor has just taken a short position in a six-month...
-
Many small-business owners have a difficult time finding financing to start or expand their business. The Small Business Administration is one potential source of financing for many types of small...
-
Selling an option rather than exercising the option and then selling the property may? results in more paper work and less cash to the may permit the seller to avoid paying short-term capital gains...
-
On Wednesday 21st June you are instructed to act for Bill Bright. He has sold his house to David Dull and there is no agent involved. You are asked to prepare the necessary documents to 'seal the...
-
As a source of capital, debt has higher costs than equity and a more immediate effect on income and expenses. Why is that?
-
Find the surface area of the volume generated when the following curve revolves around the x-axis. If you cannot evaluate the integral exactly, use your calculator to approximate it. (Round your...
-
According to Bernard Kerik, former commissioner of the New York City Police Department (and NYCDOC): "Grown men sit around...talking about old times, drugs, guns... Then you have young, nonviolent,...
-
Journal Entry 4 Reflect on what you have learned about being a community services worker through your Fieldwork Placement. For example: For you, what are the personal and professional challenges of...
-
On the 18/12/2021, a hedge fund has sold short (short selling) 100 Million Euro of the OAT 0,5% 01/12/2032 at a price of 103%. On the repo market, the bond trades at a rate of -0,5% for a 3 months...
-
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?
-
Question: Under Indian custom, many families pay a staggering dowry when their daugh- ters marry. To avoid this burdensome debt, hundreds of thousands of pregnant women each year pay for an...
-
Question: Rap artist Ice-T and his band, Body Count, recorded a song called "Cop Killer," in which the singer gleefully anticipates slitting a policeman's throat. (The lyrics to this song are readily...
-
In the fall of 2008, the nation fell into its worst economic slump in a generation. The stock market lost half its value. Many companies cut salaries and laid off workers. The unemployment rate...
Study smarter with the SolutionInn App