Question: Please Use Oracle SQL Developer to execute SQL commands to do the following. Assume there are over 100 employees in the table so you must
Please Use Oracle SQL Developer to execute SQL commands to do the following.
Assume there are over 100 employees in the table so you must create the query to return all employees that meet the criteria specified. Please separate the steps and take screenshots for the following:
Alter the Employee table add the column Emp_Cell_Phone_Num to the table. Select an appropriate data type. (For this problem, you may have used different table or attribute names in your database instance, however, the table and attribute domains should be the same regardless of the naming conventions you chose to use.)
List the Customer ID, Last Name, Ship Date, and Order ID for all Orders that have been delivered. Sort the output by Customer ID. (Note: You must JOIN Customer and Order.)
List the Order ID, Order Date, Product ID, and Product Name for all Orders shipped between any two dates you choose. (Note: You must use a Join and you must select dates that include at least two, but not all orders in your database).
Use a Subquery to list the Last Name and Start Date for all employees hired after Marilyn Hayes. (Note you must use Marilyn Haynes' name in the subquery, you cannot use her start date).
Use a Subquery to list the Last Name, Job Code, and Pay Rate for all Employees with the same Job Code as yours (Note: You must use your name in the subquery, you cannot use your job code).
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
