Answered step by step
Verified Expert Solution
Question
1 Approved Answer
List the name, salary of the employees who are clerks. Employee Table with data EMPNO ENAME MGR HIREDATE SAL DEPTNAME 1 SMITH 3 12/17/1980 800.00
- List the name, salary of the employees who are clerks.
Employee Table with data
| EMPNO | ENAME | MGR | HIREDATE | SAL | DEPTNAME |
| 1 | SMITH | 3 | 12/17/1980 | 800.00 | BANKING |
| 2 | ALLEN | 4 | 2/20/1981 | 1600.00 | INSURANCE |
| 3 | WARD | 2/22/1981 | 1250.00 | BANKING | |
| 4 | JONES | 4/2/1981 | 2975.00 | INSURANCE | |
| 5 | MARTIN | 4 | 9/28/1981 | 1250.00 | INSURANCE |
| 6 | BLAKE | 7 | 5/1/1981 | 2850.00 | SERVICES |
| 7 | CLARK | 6/9/1981 | 2450.00 | SERVICES | |
| 8 | SCOTT | 4 | 12/9/1982 | 3000.00 | INSURANCE |
| 9 | KING | 3 | 11/17/1981 | 5000.00 | BANKING |
| 10 | TURNER | 4 | 9/8/1981 | 1500.00 | INSURANCE |
| 11 | ADAMS | 3 | 1/12/1983 | 1100.00 | BANKING |
| 12 | JAMES | 7 | 12/3/1981 | 950.00 | SERVICES |
| 13 | FORD | 4 | 12/3/1981 | 3000.00 | INSURANCE |
| 14 | MILLER | 4 | 1/23/1982 | 1300.00 | INSURANCE |
Step by Step Solution
★★★★★
3.45 Rating (145 Votes )
There are 3 Steps involved in it
Step: 1
Solution Query ...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Fundamentals Of Database Systems
Authors: Ramez Elmasri, Shamkant Navathe
7th Edition
0133970779, 978-0133970777
