Details of this Paper

CIS 276

Description

solution


Question

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.;Create a query using the Employees and Jobs tables to display the JOB_ID, JOB_TITLE and MIN_SALARY for one specific employee;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;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";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.;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.;Write a query to display your name and the current date on a single line of output;Write a query to modify the previous query and display the HIRE_DATE's that are not between 1995 and 1996.;Write a query using the EMPLOYEES table that produces the following output concatenated. ?Mr.? ?,? ?can be contacted at the following phone number ? ? or at his email address of ?. Provide a column alias for each column.;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.;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.;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;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.;Write a query using the regions table to display the REGION_ID REGION_NAME for the regions whose name contains the string East;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.

 

Paper#66870 | Written in 18-Jul-2015

Price : $27
SiteLock