Usng ORACLE SQL

2. Create a report that displays the employee number, last name, and salary of all employees who earn more than the average salary of the entire company.

3. Write a query that displays the employee number and last name of all employees who work in a department with any employee whose last name begins with the letter B".

NOTE: For all these SQL statements in your answers, you must write SQL subqueries. For these subqueries, only use the table hr.employees (thus all FROM clauses are FROM hr.employees)