Answered step by step
Verified Expert Solution
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.
- List the Last Name, First Name, and Pay Rate for all Employees making more than $100,000 per year.
- List the Last Name, First Name, and Pay Rate for all Employees whose last name begins with the letter J.
- List the Last Name, First Name, and Start Date for all Employees hired after January 1, 2020.
- 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.
- List the Employee ID, Last Name, and Full address for all employees making between $90,000 and $110,000 per year.
- 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).
- 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).
- 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).
- 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).
- Change the address for Employee George Jones to 456 Stampede Ave, Cheyenne, WY.
- Increase your Pay Rate by $10,000.
- Delete Employee LaBron James from the database.
- 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started