Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please answer all parts 10. Re-run the query selecting Empno, Ename, Job, and Hiredate by copying and pasting it from your session Name the column
Please answer all parts
10. Re-run the query selecting Empno, Ename, Job, and Hiredate by copying and pasting it from your session Name the column headings Emp \#, Employee, Job, and Hire Date, respectively. 14 rows selected 11. Display the name concatenated with the job. separated by a comma and space, and name the column Employee and Title. Employee and Title KING, PRESIDENT BLAKE, MANAGER CLARK, MANAGER JONES, MANAGER MARTIN, SALESMAN ALLEN, SALESMAN TURNER, SALESMAN JAMES, CLERK WARD, SALESMAN FORD, ANALYST SMITH, CLERK SCOTT, ANALYST ADAMS, CLERK- MILLER, CLERK 14 rows selected. 12. Create a query to display all the data from the EMP table. Separate each column by a comma. Name the column THE OUTPUT. THE OUTPUT 7339,KING,PRESIDENT,17-NOV-81,5000,107693,BLAKE,MANAGER,7839,01-MAY-31,2350,,307732,CLARK,MANAGER,7339,09-JUN-31,2450,,107566,JONES,MANAGER,7339,02-APR-31,2975,,207654,MARTIN,SALESMAN,7698,28-SEP-81,1250,1400,307499,ALLEN,SALESMAN,7698,20-FEB-81,1600,300,307344,TURNER,SALESMAN,7698,08-SEP-81,1500,0,307900,JAMES,CLERK7698,03DEC81,950,307521,WARD,SALESMAN,7698,22-FEB-81,1250,500,307902,FORD,ANALYST,7566,03-DEC-81,3000,,207369,SMITH,CLERK7902,17DEC80,800,207788,SCOTT,ANALYST,7566,09-DEC-82,3000,20Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started