CIS 276

Are you pressed for time and haven’t started working on your assignment yet? Would you like to buy an assignment? Use our custom writing services for better grades. Even if your deadline is approaching fast, our writers can handle your task right when you need it. Our writers will complete your order from scratch and make sure it’s completely unique.


Order a Similar Paper Order a Different Paper

 

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.” <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.

 

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.

 

Writerbay.net

Do you need help with this or a different assignment? Even when your task is complicated and the deadline is in less than 2 days, you still have every chance to get a good grade for it. How? By completing the order form, you will get the finest custom-written assignment at an affordable price. We also deliver a number of services for free (e.g., revisions, editing, checking the text for authenticity). Use our paper writing service to receive effective help with your homework.


Order a Similar Paper Order a Different Paper