Question: For all these questions, run the SQL commands and statements in Oracle LIVE SQL. Then cut and paste your SQL statements in this Word document

For all these questions, run the SQL commands and statements in Oracle LIVE SQL. Then cut and paste your SQL statements in this Word document and submit (You dont need to show me the actual output. I just need to see your SQL statements for each of these questions). Put a semicolon; at the end of your SQL statement.

4. Retrieve the first names and last names and employee IDs from our company and display the results as First, Last, and Employee Identification Number (use the SQL Alias function to do this)make sure your display is exactly like: First Last Employee Identification Number

5. Find and display all the employees in our company (e.g. in our hr.employees table) that make a salary of 4800. For the display/output, display their first name, last name, hire date, and salary.

6. Find and display all the employees in our company that have a last name that begins with Ba For the display/output, display their employee id, first name, last name, phone number, and salary.

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 Finance Questions!