Sql questions

Assignment Help PL-SQL Programming
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.

Reference no: EM138238

Questions Cloud

An increase in autonomous investment : An increase in autonomous investment will cause equilibrium output to increase
Grade point average : Suppose at Columbia University, grade point average (GPA) and SAT scores are related by the conditional expectation
Explain how much shelter : Explain how much shelter can she buy if she purchases 2 units of food.
Average income in the town increases : If the average income in the town increases to 15, solve for the new equilibrium Quantity and equilibrium Pb.
Sql questions : 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.
Case study : Case Study: The following capital structure is taken from Bata Boots Co. balance sheet for the fiscal year ended April 30, 2005.  This is considered the firm’s optimal capital structure.
Interest equivalent factor : Interest equivalent factor,  Lori Stratton is considering investing in a bond that provides a yield of 8.35 percent or a preferred share with a yield of 7.09 percent. Lori lives in Ontario and at her level of taxable income, the federal tax rate is ..
Describe which elements make up performance reporting : Describe which elements make up performance reporting. Why are these elements necessary?  What percentage of identified risks should have response plans or contingency plans? Why?
Capital stock at the end of the year : Capital stock at the end of the year of this economy to remain constant as the beginning of the year, how much investment is needed.

Reviews

Write a Review

 

PL-SQL Programming Questions & Answers

  Create a database model

Create a database model and Submit the table creation statements for the Database Model.

  Write pl-sql procedures and functions

Write PL/SQL procedures and functions to populate and query that database

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd