1. Log in to your Oracle ApEx account.
2. Create a SQL query in the SQL command window showing the empno, ename, job, sal, hiredate, and the number of years that the employee has worked for the company from the emp table. Use the months_between() function along with the SYSDATE to show how many years the employees have been working for the company. Limit your results to employees who have been working for the company more than 35 years.
Copy and paste your SQL query along with a screenshot of your result set into your assignment.
3. Create a SQL query in the SQL command window showing the empno, ename, job, sal, hiredate from the emp table. Use the hiredate column to get all of the employees hired in 1980 and all of the employees hired in the first four months of 1981.
Copy and paste your SQL query along with a screenshot of your result set into your assignment.