ECET 450 Week 4 Practice Exercises New Work

ECET 450 Week 4 Practice Exercises New Work

FOR QUESTIONS 1-10: Given the following table named DEPT,

DEPTNO          DNAME            LOC

10

20

30

40        ACCOUNTING

RESEARCH

SALES

OPERATIONS New Work YORK

DALLAS

CHICAGO

BOSTON

Write an SQL script for the following returned data: