Get a unique, high-quality and non-plagiarized paper from us today at the most affordable price
Email us :



  1. Create a query to display the country name and region id of the countries with a region_id greater than 2.
  2. Create a query to display the country name and region id of the countries for one specific country.
  3. Write a query to display your name, and the current date on a single line of output.
  4. Display using the job_history table the EMPLOYEE_ID, JOB_ID, START_DATE, and END_DATE, of every employee who was terminated after 1997.
  5. Write a query using the employees table to determine what salaries would be if the employees were given a 15% raise. Label the column New Salary. Display four columns from the employees table including the salary column.
  6. For each Employee in the job_history table display the employee_id, job_id, department_id and calculate the number of months between the start_date and the end_date. Label the column MONTHS BETWEEN. Round the number of months up to the closest whole number.
  7. Write a query using the jobs table that produces the following output concatenated. , has a minimum salary of, , but a maximum salary that is more than the min_salary. Provide a column alias for each column.
  8. Write a query using the countries table to display the STREET_ADDRESS with the first letter capitalized and all other letters lowercase and the length of the CITY.
  9.         Write a query using the countries table to display the country id, and country name for three specific regions without using the ‘or’ operator.
  10. Write a query using the countries table to display the country id, and country name for three specific regions whose country_name ends with an s.
  11. 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 null.
  12. Create a query that will display the department number, department name and location id. If the department does not have a location id put “No Location is Listed”. Create an alias for the column.
  13. Write a query using the job_history table to display the employee id, start date, and end date for all employees with an end date of 15 March 1997.
  14. Display the highest, sum, and average actual salary of all employees in the employees table. Label the columns Maximum, Sum and Average “Actual Salary”, respectively. Round your results to the nearest whole number.
  15. Write a query to display the number of job id’s with the same salary.
  16. Write a query that will display the difference between the highest and lowest start_date in the job_history table. Label the column “Highest and Lowest”.
  17. Write a query using the jobs and job_history tables to display the job id , department id, and job title for all employees.
  18. Write a query to display the employee last name, email, phone_number, and start_date of all employees who earn a commission.


Do you want your assignment written by the best essay experts? Then look no further. Our teams of experienced writers are on standby to deliver to you a quality written paper as per your specified instructions. Order now, and enjoy an amazing discount!!

How to Place an Order 

Send the assignment details such as the instructions, due date/deadline, number of pages and college level to the customer support agent online on live chat,  fill in the assignment details at place an order or send the information to our email address and a customer support agent will respond to you immediately. 

Once you place your order, we choose for you the best and competent writer for your assignment based on each writer’s competence in handling a subject. 

When the homework is completed, we have a quality assurance team that proofreads the assignment to ensure it meets the required rubric instructions from your professor.

After thorough review of your assignment, we send the paper to the client. In case you need any changes at this point, you can let us know so that we can handle it for you at no extra charge. 

Homework Help Website

Why we should write your Paper 

  1. Money Return guarantee
  2. 0% Plagiarism Rate
  3. Guaranteed Privacy
  4. Written from scratch by highly qualified writers 
  5. Communication at Any Time (24/7)
  6. Flexible Pricing and Great Discount Programs
  7. Timely Deliveries
  8. Free Amendments
Looking for a similar assignment and in urgent need for help? Place your order and have excellent work written by our team of professionals to ensure you acquire the best grades.

  We are here to assist you.


Statistics about Us

130 New Projects
235 Projects in Progress
315 Inquiries
420 Repeat clients

© 2021 Premiered Tutorials
All rights reserved. We provide online custom written papers, such as term papers, research papers, thesis papers, essays, dissertations and other custom writing services.

All papers inclusive of research material are strictly intended to be used for research and study purposes only. Premiered Tutorials does not support or condone plagiarism in any form. These custom papers should be used with proper reference.

Place an Order
error: Content is protected !!