ECET450 Practice Exercise #4 Complete Solution

Student Name:__________________        Date:_________
ECET450 Practice Exercise #4

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

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:

ECET450 Practice Exercise #4 Complete Solution

• ECET450 Practice Exercise #4 Solution.docx 28 KB

Pay only $20.00

Rating: A+ Purchased: 11 x Posted By: Vikas

• «
• 1
• 2
• 3
• »

A+ - Thank you!

Vikas

Thanks for the positive feedback!