List the employees who have salary between 1000&2000 (using AND Operator) EMPNO ENAME 7369 SMITH 7499 ALLEN
Fantastic news! We've Found the answer you've been seeking!
Question:
- List the employees who have salary between 1000&2000 (using AND Operator)
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
Fundamentals Of Database Systems
ISBN: 9780133970777
7th Edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date:
Students also viewed these databases questions
-
List the employees who have salary between 1000&2000. 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...
-
Using the union operator, retrieve the list of employees who are neither managers nor supervisors. Attributes to be retrieved are first name, last name, position, sex and department number.
-
Using the average baseball salary from 2000 through 2012 data for Problem 16.18 on page 626 (stored in BBSalaries). a. Fit a third-order autoregressive model to the average baseball salary and test...
-
Draw the BST that results when you insert the keys E A S Y QUE S T I O N in that order into an initially empty tree. What is the height of the resulting BST?
-
Compute the present value of $5,000 paid in two years using the following discount rates: 8 percent in the first year and 7 percent in the second year.
-
List the errors you find in the following partial balancesheet: Contours Company Balance Sheet December 31, 2012 Assets Total current assets 350,000 Replacem Accumulated Book Value Cost Property,...
-
One critical-thinking skill is a heightened awareness of the danger of reaching a conclusion prior to acquiring missing information that were it known would have a reasonable probability of altering...
-
Autotech Manufacturing is engaged in the production of replacement parts for automobiles. One plant specializes in the production of two parts: Part 127 and Part 234. Part 127 produced the highest...
-
Explain how the relative prices of rugs and robots in autarky compare with the relative prices when Canada and India start to trade? In your answer explain which country will export/import which...
-
(a) The steps in the accounting cycle for a merchandising company differ from the steps in the accounting cycle for a service company. Do you agree or disagree? (b) Is the measurement of net income...
-
During the year, Brown Corporation's average accounts receivable were $316,000. The current-year income statement reported net sales of $2,010,000, uncollectible accounts expense of $118,000, and net...
-
Meg wants to give Lori a pair of diamond earrings that Meg has in her safe-deposit box at First National Bank. Both Lori and Meg are signatories for that safe deposit box. Meg gives Lori the key to...
-
An automatic stay is a suspension of all judicial proceedings on the occurrence of an independent event. (True/False)
-
Benas files a bankruptcy petition under Chapter 7 to have his debts discharged. If Benas plan is approved, the debts most likely to be discharged include claims for a. back taxes accruing within...
-
When two secured parties have perfected security interests in the same collateral, generally the last to perfect has priority. (True/False)
-
Bankruptcy proceedings are held in federal bankruptcy courts. (True/False)
-
An investor has entered into a forward contract of gold. He has taken a long position. Each contract has 100 ounces. He entered the position at 875.6 dollars per ounce. The initial margin requirement...
-
Describe the general ways that the revised Form 990, applicable for tax year 2008 and beyond, is different from previous versions.
-
Compare the file commands listed in Section 16.5 to those available on a file access method you are familiar with.
-
List the important tasks mentioned that are involved in analyzing Web content. Describe each in a couple of sentences.
-
Discuss what is meant by each of the following terms: database authorization, access control, data encryption, privileged (system) account, database audit, audit trail.
-
The system in Fig.12.21 consists of a homogeneous disk of mass \(M=300 \mathrm{~g}\) and radius \(R=40.0 \mathrm{~cm}\). At the disk, a slit has been produced along the entire length \(R\) of the...
-
Determine the energy flux on Earth from the Sun, which is \(150 \times 10^{6} \mathrm{~km}\) away, using (13.12). Taking into account that a photovoltaic panel can have an efficiency of \(20 \%\),...
-
Show that if you have a mass \(M\) distributed of on a spherical shell, that is, on a sphere of radius \(R\) hollow inside, and a point mass \(m\) at a distance \(h\) from the sphere, the...
Study smarter with the SolutionInn App