List the name of employees who joined during 1981. EMPNO ENAME 7369 SMITH 7499 ALLEN 7521 WARD
Fantastic news! We've Found the answer you've been seeking!
Question:
List the name of employees who joined during 1981.
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
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these databases questions
-
List the name of each employee, his or her birth date, the name of his or her manager, and the manager's birth date for those employees who were born before their manager was born; label the...
-
1. List the name of each publisher thats not located in New York. 2. List the title of each book published by Penguin USA. 3. List the title of each book that has the type MYS. 4. List the title of...
-
1. List the name of each publisher thats not located in New York. 2. List the title of each book published by Penguin USA. 3. List the title of each book that has the type MYS. 4. List the title of...
-
Consider a stylized two-period model with banking. The aggregate abatement cost function in period t is given by C(E)= (a t be) 2 /2b with a 1 < a 2 is D(E)=dE 2 /2. (a) Determine the optimal...
-
On May 15, Gotts Outback Clothiers borrowed some money on a 4-month note to provide cash during the slow season of the year. The interest rate on the note was 8%. At the time the note was due, the...
-
The manager of a seafood restaurant wants to establish a price on shrimp dinners. Experimenting with prices produced the following data: a. Plot the data as a scatter plot, determine the regression...
-
You must decide whether or not to purchase new capital equipment. The cost of the machine is \($5,000.\) It will produce the following cash flows. The appropriate discount rate is 10 percent. Should...
-
1. What action would you recommend to the Board of Regents? 2. How should Strutledge go about making a strategic decision such as this? Strutledge is a small private liberal arts school located...
-
The SM-Shoemart website, in its history page, states that "SM was founded as a shoe store by Henry Sy, Sr., in October 1958 in downtown Manila(SM, n.d.)." How can this simple information help protect...
-
Roman Systems Inc. (RSI) is a Canadian private company. It was incorporated in Year 1 by its sole common shareholder, Marge Roman. RSI manufactures, installs, and provides product support for its...
-
The author includes the detail about Burn's district being "mostly opposed to the amendment" to help explain which earlier line?
-
Susu Segar Sdn Bhd is the producer of dairy products. One of its products, Milky is the main product for the company. The production of Milky involves two sequential processing departments namely...
-
Project Y requires a $309,000 investment for new machinery with a five-year life and no salvage value. The project yields the following annual results. Cash flows occur evenly within each year. (PV...
-
Currently a mutual fund has a NAV of $ 6 7 . 8 0 and a market price of $ 6 5 . 2 4 what is the percentage premium or discount af which the fund is trading?
-
1.The Greenwood Company's balance sheet on June 30, 20X3, has total assets of $75,000, total liabilities of $30,000, paid-in-capital of $25,000, and retained earnings of $20,000. During the month of...
-
You bought a stock three months ago for $ 4 3 . 5 3 per share. The stock paid no dividends. The current share price is $ 4 7 . 2 4 . What is the APR of your investment? ( Do not round intermediate...
-
A dealer purchases Treasury notes, but needs to borrow money to pay for the purchase. The dealer will often borrows by ____. A repo Buying collateral A reverse repo matched book
-
Question 2 For an n x n matrix A = form) via (aij)
-
Define each of the following terms: a. Base table b. Data definition language c. Data manipulation language d. Dynamic view e. Materialized view f. Referential integrity constraint g. Relational DBMS...
-
Why must some identifiers be composite rather than simple?
-
Write SQL queries to answer the following questions: a. What are the names of the course(s) that student Altvater took during the semester 1-2015? b. List names of the students who have taken at...
-
What are G.E. Moulton's fraud identifiers?
-
Give the percentages when CEOs and CFOs are involved in fraudulent financial fraud cases.
-
What was the pressure on Tracey Henderson, an executive of the Australia Football League, to steal?
Study smarter with the SolutionInn App