Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help with this. Use SQL Developer to execute SQL commands to do the following. Assume there are over 100 employees in the table so

Need help with this.

Use SQL Developer to execute SQL commands to do the following. Assume there are over 100 employees in the table so you must create the query to return all employees that meet the criteria specified. Include your name, Instructors name and the data as a comment on all screenshots.

  1. List the Last Name, First Name, and Pay Rate for all Employees making more than $100,000 per year.
  2. List the Last Name, First Name, and Pay Rate for all Employees whose last name begins with the letter J.
  3. List the Last Name, First Name, and Start Date for all Employees hired after January 1, 2020.
  4. Use the IN operator to list the Last Name, First Name, Job Code, and Start Date for all Employees with a Job Code of 100, 200 or 400.
  5. List the Employee ID, Last Name, and Full address for all employees making between $90,000 and $110,000 per year.
  6. Show the minimum and average pay rate for all employees in the organization. (Note: Use a single SQL statements, the output should include only one line).
  7. Show the Warehouse ID, Minimum, and Average Pay Rate for employees assigned to each warehouse. (Note: The output should include one line for each warehouse).
  8. Show the Warehouse ID, Minimum, Average Pay Rate, and number of employees in each warehouse. Only include employees with a Pay Rate above $90,000 (Note: The output should include one line for each warehouse).
  9. Show the Warehouse ID, Minimum, Average Pay Rate, and number of employees in each warehouse. Only include warehouses where the average Pay Rate is above $100,000 (Note: The output should include one line for each warehouse. You will need to use the Having Clause to make this work properly).
  10. Change the address for Employee George Jones to 456 Stampede Ave, Cheyenne, WY.
  11. Increase your Pay Rate by $10,000.
  12. Delete Employee LaBron James from the database.
  13. Alter the Employee table add the column Emp_Cell_Phone_Num to the table. Select an appropriate data type.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Spatial Databases 2nd Symposium Ssd 91 Zurich Switzerland August 1991 Proceedings Lncs 525

Authors: Oliver Gunther ,Hans-Jorg Schek

1st Edition

3540544143, 978-3540544142

More Books

Students also viewed these Databases questions

Question

600 lb 20 0.5 ft 30 30 5 ft

Answered: 1 week ago

Question

b. What are its goals and objectives?

Answered: 1 week ago