Reference no: EM138238

1. Write a query to display using the employees table the EMPLOYEE_ID, FIRST_NAME, LAST_NAME and HIRE_DATE of every employee who was hired after to 1 January, 1995.

2. Write a query using the departments table that displays the department number, department name, manager id and location id where the manager id or location id is not null.

3. Write a  query to display the last name, first_name, hire date and end date of employees using the employees table and the job_history table.

4. Write a query to display the average max_salary of all employees in the jobs table.  Label the column “Average Max Salary”.  Truncate your results to the nearest whole number.

5. Write a query using the JOBS table to determine the what the MAX_SALARY would be if the employees were given a 5% raise. Label the column New Max Salary. Display four columns from the employees table including the salary and the New Max Salary column.

6. Using the employees table  write a query to display the employee numbers, department id, and hire date, which is the first Thursday three months from the hire date. Format the dates to appear in the format similar to "Thursday the Fifteenth of July, 2001"

 

7. Write a query to modify the previous query and display the HIRE_DATE's that are not between 1995 and 1996.

8. Write a query using the EMPLOYEES table that produces the following output concatenated. “Mr.” <first_name> “,” <last_name> “can be contacted at the following phone number   ”  <phone> “ or at his email address of   “ <email>.   Provide a column alias for each column.

9. Write a query using the employees table to display the last name, first name  and hire date for three specific employees without using the ‘or’ operator.

10. For each Employee in the employees table  write a query to display the employee_id, job_id, department_id and calculate the number of months between the hire_date and todayï's date. Label the column MONTHS FROM HIRING. Round the number of months up to the closest whole number.

11. Create a query using the Jobs table to display the JOB_ID, JOB_TITLE and MIN_SALARY with a MIN_SALARY greater than $4000.00.

12. Write a query using the regions table to display the REGION_ID REGION_NAME for the regions whose name contains the string East.

13. Create a query  using the Employees and Jobs tables to display the JOB_ID, JOB_TITLE and MIN_SALARY for one specific employee.

14. Write a query to display your name and the current date on a single line of output

15. Write a query using the employees table to display the LAST_NAME, JOB_ID, and HIRE_DATE for employees whose last name begins with a G.