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
Get step-by-step solutions from verified subject matter experts
