Question: Create a new table spec_emp that includes the ename, job, mgr, hiredate, sal, and comm columns from the emp table. Include only those employees that

Create a new table spec_emp that includes the ename, job, mgr, hiredate, sal, and comm columns from the emp table. Include only those employees that have the same hiredate as James. Show your sql below.

Show me code step by step exact what to insert in sql and or screen shot of code and run it.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Given the following code in Oracle SQL Developer , please help me answer the question below : The relational schemas are: Dept (DEPTNO, DNAME, LOC) pk = {DEPTNO} Emp (EMPNO, ENAME, JOB, MGR,...

Q:

Given the following code in Oracle SQL Developer , please help me answer the question below : The relational schemas are: Dept (DEPTNO, DNAME, LOC) pk = {DEPTNO} Emp (EMPNO, ENAME, JOB, MGR,...

Q:

Given the following code in Oracle SQL Developer , please help me answer the question below : The relational schemas are: Dept (DEPTNO, DNAME, LOC) pk = {DEPTNO} Emp (EMPNO, ENAME, JOB, MGR,...

Q:

Given the following code in Oracle SQL Developer , please help me answer the question below : The relational schemas are: Dept (DEPTNO, DNAME, LOC) pk = {DEPTNO} Emp (EMPNO, ENAME, JOB, MGR,...

Q:

SQL Queries to Develop Develop SQL statements using the EMP and DEPT tables explained in Oracle APEX. Use Oracle APEX to try out and test each SQL statement. Note that SAL is a month salary. Send in...

Q:

SQL Queries to Develop SQL statements. Develop SQL statements using the EMP and DEPT tables explained in the lecture notes and available in Oracle APEX. Use Oracle APEX to try out and test each SQL...

Q:

Write a query to get the average salaries of jobs grouped by their department number. List all employees in the Sales, and Operations departments using subquery. Write a query to get the maximum...

Q:

write the OUTPUT below each query. Create an SOL STATEMENT for each query and write it on the right. Test your SQL statements and save your results. OUTPUT 1. Name and salary of all clerks. OUTPUT:...

Q:

WRITE THE QUERIES FOR THE FOLLOWING QUESITONS (USING QSL ORACLE). 11.Write a query to display the employees number, name, salary, department name of all the MANAGERS and CLERKS working in New York,...

Q:

EMPLOYEE TABLE (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) DEPT (DEPTNO, DNAME, LOC) Solve the following DML queries for the above two tables. 1.Display the name of all the clerks who...

Q:

IcyPop Inc. is an ice cream manufacturing company. It produces two major types of ice-cream products: FruityGo and BerryWafers. You have been brought on as an Analyst, with your first task being to...

Q:

(a) Prove that Îμαβ = Îμβα in any coordinate system in a curved Riemannian space. (b) Use this to prove...

Q:

Super keyword in java is used to Refer immediate parent class instance variables. Invoke immediate parent class constructor. Invoke immediate parent class methods. All

Q:

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

Q:

C Does avoiding saying (or printing) the word give it more or less power?

Q:

A What meaning does the N-word carry for you? Does it seem appropriate to use it in a scholarly discussion? How do you feel about its being printed (or not printed) in this textbook?

Q:

What are your personal thoughts on sex, gender, and language? Do you think men and women speak different languages, or do you feel that we all speak more similarly than differently? How do your...