Question: 2. Run the SQL statement that would display the first names, last names, and the hire dates for the following employees: Ellen Abel, Amit Banda,
2. Run the SQL statement that would display the first names, last names, and the hire dates for the following employees: Ellen Abel, Amit Banda, and Harrison Bloom (this report must contain this information for the three employees in one display/reportmeaning dont run three different SQL statements, one for each employee).
3. For question #2 above, add one SQL clause/line at the end to sort the output by last names in descending order.
4. Create a report from our hr.employees database table that displays employees first name, last name salary, job id, and phone number of all employees that have the job id of AD_VP or SA_REP or HR_REP.
Sort the output first by Ascending order of last names then by Descending order of first_names.
5. Create a report with employee first and last names, their hire date, and job id for all employees who make at least $11,000 and their job ids are (SA_MAN) or (PU_MAN). Make sure your output report displays the employees sorted in descending order by last name.
(Note: Your Output Report should return 5 rows/records)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
