For questions 1-10nbspgiven the following table

Question

FOR QUESTIONS 1-10: Given 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

2.

DNAME

SALES OPERATIONS

3.

DNAME

ACCOUNTING RESEARCH SALES OPERATIONS

4.

DNAME	LOC
RESEARCH SALES OPERATIONS	DALLAS CHICAGO BOSTON

5.

DEPT NO	DNAME	LOC
10 20 30	ACCOUNTING RESEARCH SALES	NEW YORK DALLAS CHICAGO

 6.

DNAME	LOC
RESEARCH SALES OPERATIONS	DALLAS CHICAGO BOSTON

 7.

Great Seafood

BOSTON

8.

LOC

NEW YORK CHICAGO

9.

DEPTNO	DNAME	LOC
40 30 20 10	OPERATIONS SALES RESEARCH ACCOUNTING	BOSTON CHICAGO DALLAS NEW YORK

 10.

DNAME

OPERATIONS RESEARCH ACCOUNTING