the following table named DEPT DEPTNO DNAME LOC 10 20 30 40 ACCOUNTING RESEARCH
ID: 662436 • Letter: T
Question
the following table named DEPT
DEPTNO
DNAME
LOC
10
20
30
40
ACCOUNTING
RESEARCH
SALES
OPERATIONS
NEW YORK
DALLAS
CHICAGO
BOSTON
Write an SQL script for the following returned data:
1.
LOC
BOSTON
ANSWER:
2.
DNAME
SALES
OPERATIONS
ANSWER:
3.
DNAME
ACCOUNTING
RESEARCH
SALES
OPERATIONS
ANSWER:
4.
DNAME
LOC
RESEARCH
SALES
OPERATIONS
DALLAS
CHICAGO
BOSTON
ANSWER:
5.
DEPT NO
DNAME
LOC
10
20
30
ACCOUNTING
RESEARCH
SALES
NEW YORK
DALLAS
CHICAGO
ANSWER:
6.
DNAME
LOC
RESEARCH
SALES
OPERATIONS
DALLAS
CHICAGO
BOSTON
ANSWER:
7.
Great Seafood
BOSTON
ANSWER:
8.
LOC
NEW YORK
CHICAGO
ANSWER:
9.
DEPTNO
DNAME
LOC
40
30
20
10
OPERATIONS
SALES
RESEARCH
ACCOUNTING
BOSTON
CHICAGO
DALLAS
NEW YORK
ANSWER:
10.
DNAME
OPERATIONS
RESEARCH
ACCOUNTING
ANSWER:
DEPTNO
DNAME
LOC
10
20
30
40
ACCOUNTING
RESEARCH
SALES
OPERATIONS
NEW YORK
DALLAS
CHICAGO
BOSTON
Explanation / Answer
1. select LOC from DDEPT where LOC='BOSTON';
2. select DNAME from DEPT where DNAME='SALES' and DNAME='OPERATIONS';
3. select DNAME from DEPT;
4. select DNAME,LOC from DEPT where DNAME <> 'ACCOUNTING';
5. select * from DEPT where DNAME <> 'OPERATIONS';
6. same as ans 4.
7.
8. select DNAME from DEPT where LOC='NEW YORK' and LOC='CHICAGO';
9. select * from DEPT ORDER BY DEPTNO DESC;
10.select DNAME from DEPT where DNAME <> 'SALES';
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.