Your Perfect Assignment is Just a Click Away
We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!

glass
pen
clip
papers
heaphones

Show the structure of the EMPLOYEES table. Select all data from the EMPLOYEES table

Show the structure of the EMPLOYEES table. Select all data from the EMPLOYEES table

Questions:     Show the structure of the EMPLOYEES table. Select all data from the EMPLOYEES table. Select the first and last column of the EMPLOYEES table. Create a query to display the JOB_ID, JOB_TITLE  and                   MIN_SALARY with a  MIN_SALARY greater than $4000.00. Create a query to display the JOB_ID, JOB_TITLE  and                   MIN_SALARY for one specific employee. Write a query to display your name and the current date on a single line of output.  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 modify the previous query and display the HIRE_DATE’s that are not between 1995 and 1996. 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. Using the employees table 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€ For each Employee in the employees table 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. 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 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 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 departments table that displays the department number, department name, manager id and location id where the manager id or location id is not null. Create a query that will display the EMPLOYEE ID, LAST_NAME  and MANAGER_ID of employees in the employee table.  If the employee does not have a manger put ‘No Manger is Listed€.   Create an alias for the column. Write a query using the employees table to display the employee id, hire date , and salary for all employees with an hire date of December 19, 1999. 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.  Display the last name, first_name, hire date and end date of employees using the employees table and the job_history table.  Modify #20 so that it only lists employees with a department id of 20, 50 or 90. Write a query to display a unique listing of the number of job id’s . Determine the number of job id’s without listing them.  Label the column Number of Jobs. Write a query that will display the difference between the highest hire date and lowest end date in the employee and job_history tables.  Label the column ‘Highest and Lowest€. Write a query using the job_history table  to display the job id , department id, and job title and months between the END_DATE and START_DATE. Write a query to display the employee last name, email, phone_number, and start_date of all employees who earn a commission.  Create a query that displays an evaluation of the employee’s salary where the salary is between the minimum salary and the maximum salary in the jobs table.  Display the last names, department numbers, the minimum salary and the maximum salary. Give each column an appropriate label.    

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: I'm Homework Free only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by I'm Homework Free are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. I'm Homework Free is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At I'm Homework Free, we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.