Question: DEPT ( 6 ) DEPTNO 1 0 2 0 3 0 4 0 DNAMEAERCSRHE SALESACOUNTGILOCWEN YORK DALLASCHAIGOOPERATIONSBOSTONPage 2 of 4 EMPE M P N O
DEPTDEPTNODNAMEAERCSRHE SALESACOUNTGILOCWEN YORK DALLASCHAIGOOPERATIONSBOSTONPage of EMPE M P N OMGR HIREDATESALDEC FEBFEBA PRSEPMAYJUNA PRNOVSEPM AYDECDECJANCOMMD E P T N O c Display hte names oafl employees with an A ni their name. d Dspialy het manse and hire daets ofal employees ni the order they wer ehrdi. e Display hte department number and number of clerks ni each department. E N A M E SMITHA L L E N WARDJ O B KRELCSALESMAN MSAENALSJONES MANAGER MARTINSALESMANBLAKEAKRLC SCOTTKNIG RENRUTADAIMSJ A M E SFORD RELMIMANAGERMANAGER ANALYSTPRESIDENT SALESMANCLERK RKECLANAYLTSCLERKUSE THESE TWO TABLES TO WRITE SQL STATEMENTS FOR THE FOLLOWING:a Display al information ni het tables EMPb Display het names and salaries of al employees with asalary greater than t Display the name of eachemployee with his department name.g Display hte names and obj titles fo al employees with hte same job sa Jones.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
