O EMPNO ENAME 1 7521 WARD 2 7654 MARTIN SALESMAN 7698 28-SEP-81 1250 3 7934 MILLER CLERK JOB M... Y HIREDATE SAL COMM DEPTNO SALESMAN 7698 22-FEB-81 1250 500 1400 7782 23-JAN-82 1300 (nul1) 30 30 10 2. Select all employees in salary grade 1 and 3. 308 10 MGR HIREDATE 10 SAL COMM }EMPNO 1 7369 SMITH CLERK 2 7499ALLEN SALESMAN 7698 20-FEB-81 1600 3 7844 TURNER SALESMAN 7698 08-SEP-81 1500 4 7876ADAMS CLERK 5 7900 JAMES CLERK ENAME DEPTNO 7902 17-DEC-80 800 (nul1) 300 20 30 0 30 20 7788 23-MAY-87 1100 (null) 7698 03-DEC-81 950 (null) 223
O EMPNO ENAME 1 7521 WARD 2 7654 MARTIN SALESMAN 7698 28-SEP-81 1250 3 7934 MILLER CLERK JOB M... Y HIREDATE SAL COMM DEPTNO SALESMAN 7698 22-FEB-81 1250 500 1400 7782 23-JAN-82 1300 (nul1) 30 30 10 2. Select all employees in salary grade 1 and 3. 308 10 MGR HIREDATE 10 SAL COMM }EMPNO 1 7369 SMITH CLERK 2 7499ALLEN SALESMAN 7698 20-FEB-81 1600 3 7844 TURNER SALESMAN 7698 08-SEP-81 1500 4 7876ADAMS CLERK 5 7900 JAMES CLERK ENAME DEPTNO 7902 17-DEC-80 800 (nul1) 300 20 30 0 30 20 7788 23-MAY-87 1100 (null) 7698 03-DEC-81 950 (null) 223
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
Maximum time I'm getting incorrect answer
Please give right approach.
Transcribed Image Text:Part A - SCOTT Schema
1. Select all employees in salary grade 2.
EMPNO ENAME
1 7521 WARD
JOB
M...Y HIREDATE
SAL
COMM
DEPTNO
SALESMAN 7698 22-FEB-81 1250
500
1400
7782 23-JAN-82 1300 (null)
30
2 7654 MARTIN SALESMAN 7698 28-SEP-81 1250
30
3 7934 MILLER CLERK
10
2. Select all employees in salary grade 1 and 3.
COMM
7902 17-DEC-80 800 (null)
300
EMPNO ENAME
JOB
MGR
HIREDATE
O SAL
DEPTNO
17369 SMITH CLERK
27499ALLEN SALESMAN 7698 20-FEB-81 1600
3 7844 TURNER SALESMAN 7698 08-SEP-81 1500
4 7876ADAMS CLERK
5 7900 JAMES CLERK
30
7788 23-MAY-87 1100 (null)
7698 03-DEC-81 950 (null)
20
30
3. Select all employees located in Chicago.
EMPNO ENAME
JOB
MGR
HIREDATE
SAL
t COMM
DEPTNO
1 7499ALLEN SALESMAN 7698 20-FEB-81 1600
300
30
2 7521 WARD
SALESMAN 7698 22-FEB-81 1250
500
30
3 7654 MARTIN SALESMAN 7698 28-SEP-81 1250
1400
30
4 7698 BLAKE MANAGER 7839 01-MAY-81 2850 (null)
5 7844 TURNER SALESMAN 7698 08-SEP-81 1500
6 7900 JAMES CLERK
30
30
7698 03-DEC-81 950 (null)
30
O0000
N3323m
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY