Description of this paper

WEEK 4 -ECET450 PRACTISE EXCERCISE ASSIGNMENT

Description

solution


Question

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

 

Paper#65757 | Written in 18-Jul-2015

Price : $22
SiteLock