1 write a query to display using the employees table the

Assignment Help PL-SQL Programming

Reference no: EM13354162

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.

Reference no: EM13354162

Questions Cloud

With the help of appropriate diagrams explain the following : with the help of appropriate diagrams explain the following statement whether it is true false or uncertain an increase

Q 1 suppose at columbia university grade point average gpa : q. 1. suppose at columbia university grade point average gpa and sat scores are related by the conditional expectation

Q1 suppose we use two inputs lets say capital and labor and : q1. suppose we use two inputs lets say capital and labor and the price of capital is pk and the price of labor is pl.

Qassume that the equation for demand for bread at a small : q.assume that the equation for demand for bread at a small bakery is qd 60 - 10pb 3y where qd is the quantity of

1 write a query to display using the employees table the : 1. write a query to display using the employees table the employeeid firstname lastname and hiredate of every employee

Question 1-nbspdescribe which elements make up performance : question 1-nbspdescribe which elements make up performance reporting. why are these elements necessary?nbspquestion 2

Qthe equation of capital accumulation is k k i - deltak : q.the equation of capital accumulation is k k i - deltak where k is the capital stock at the beginning of the year i

Q1 a in recent years abc company has requested the services : q1. a. in recent years abc company has requested the services listed below from blazo economic an economic

Qanthony figueroa is a cpa who works for an accounting : q.anthony figueroa is a cpa who works for an accounting consulting firm. his annual salary income is 70000. anthony is

User Account

All Pages