REQUIRED Week 4 Assignment*****NOTE IF YOU MADE CHANGES TO

REQUIRED: Week 4 Assignment*****NOTE: IF YOU MADE CHANGES TO YOUR WEEK 1 AND/OR 2 CREATE TABLE CODE, MAKE SURE TO SUBMIT THE CORRECTED CODE WITH THE WEEK 4 ASSIGNMENT SO THAT I HAVE THE MOST CURRENT CODE THAT WILL EXECUTE WITHOUT ERRORS!!!!******Updating Columns/Using Aggregate functionsREQUIRED: Prepare ALL Code per the Coding Standards document attached with this assignment. Use the database and tables from previous week’s assignment. Write SQL queries using the SQL SELECT statement. NOTE: One SQL Query contains only one SELECT statement and only one FROM statement and may use other statements and clauses to complete the query. See sample queries in the Course Materials forum.REQUIRED: Use Each Assignment Request Below As The ‘Comment’ For Each Query. Copy and paste the Assignment request between 2 multi-line comment indicators. A multi-line comment indicator is a slash and an asterisk – the comments – and then an asterisk and slash: /*comments*/: Example: /* Assignment Request: Write one SQL Query to Increase all employees’ salaries with the selected Job Class by 5.375%. (You select the Job Class of your choice.)*/——————————————————————————————————————Assignment Request: (3 parts to this request)Run a SELECT statement that returns all the records from the Job Title table JOINED to the Employee table.REQUIRED: Create the Code, execute the code without errors and take a screen shot of the code and message showing the code in the current screen. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.Write one SQL Query to Increase all employees’ salaries with the selected Job Class by 4.568%. (You select the Job Classification of your choice.)Run a ‘New’ SELECT statement that returns all the records from the Job Title table JOINED to the Employee table.REQUIRED: Execute the code without errors and take a screen shot of the code and message showing the code in the current screen. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.Should have screenshots of before and after.——————————————————————————————————————Assignment Request: (3 parts to this request)Run a SELECT statement that returns all the records from the EMPLOYEE table.REQUIRED: Create the Code, execute the code without errors and take a screen shot of the code and message showing the code in the current screen. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.Write one SQL Query to Increase all employees’ salaries by 2.091%.REQUIRED: Create the Code, execute the code without errors and take a screen shot of the code and message showing the code in the current screen. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.Run a SELECT statement that returns all the records from the EMPLOYEE table.REQUIRED: Execute the code without errors and take a screen shot of the code and message showing the code in the current screen. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.Should have screenshots of before and after.——————————————————————————————————————Assignment Request: (3 parts to this request)Run a SELECT statement that returns all the records from the EMPLOYEE table.REQUIRED: Create the Code, execute the code without errors and take a screen shot of the code and message showing the code in the current screen. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.Write one SQL Query to Delete employee:

by Employee ID, First Name and Last Name.Run a SELECT statement that returns all the records from the EMPLOYEE table.REQUIRED: Execute the code without errors and take a screen shot of the code and message showing the code in the current screen. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.Should have screenshots of before and after.——————————————————————————————————————Write Queries: REQUIRED: Use Each Assignment Request Below As The ‘Comment’ For Each Query. Copy and paste the Assignment request between 2 multi-line comment indicators. A multi-line comment indicator is a slash and an asterisk – the comments – and then an asterisk and slash: /*comments*/: Example: /* Assignment Request: Write one SQL Query to Increase all employees’ salaries with the selected Job Class by 5.375%. (You select the Job Class of your choice.)*/ REQUIRED: ALL queries must return results that fit the query request. When 3 tables are joined, then all the data must be displayed for all three tables. The number of records will differ depending on the type of join used.——————————————————————————————————————Assignment Request: Write one SQL Query to calculate the average Age for all employees. (Output shows Alias)REQUIRED: Create the Code, execute the code without errors and take a screen shot of the code and message showing the code in the current screen and the results from the query. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.——————————————————————————————————————Assignment Request: Write one SQL Query to calculate the average Salary for all employees. (Output shows Alias)REQUIRED: Create the Code, execute the code without errors and take a screen shot of the code and message showing the code in the current screen and the results from the query. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.——————————————————————————————————————Assignment Request: Write one SQL Query to calculate the maximum salaries for employees by Job Classification. (Output shows Alias)REQUIRED: Create the Code, execute the code without errors and take a screen shot of the code and message showing the code in the current screen and the results from the query. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.——————————————————————————————————————Assignment Request: Write one SQL Query to calculate the maximum salary for all employees. (Output shows Alias) REQUIRED: Create the Code, execute the code without errors and take a screen shot of the code and message showing the code in the current screen and the results from the query. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.——————————————————————————————————————Assignment Request: Write one SQL Query to calculate the minimum salaries for Employees by Job Title. (Output shows Alias)——————————————————————————————————————Assignment Request: Write one SQL Query to calculate the minimum salary for all employees. (Output shows Alias)REQUIRED: Create the Code, execute the code without errors and take a screen shot of the code and message showing the code in the current screen and the results from the query. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.——————————————————————————————————————Assignment Request: Write one SQL Query to Count all employees and GROUP BY Age and Gender. (Output shows Alias)REQUIRED: Create the Code, execute the code without errors and take a screen shot of the code and message showing the code in the current screen and the results from the query. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.——————————————————————————————————————DUE MONDAY! WHAT TO SUBMIT: Review the Grading Rubric before you upload and submit the Assignment.Note: There will be two (2) Attachments for this assignment (Please DO NOT ZIP files)Submit only One (1) Notepad attachment with ‘all’ code and One (1) Word document with all screenshots.NOTE: submitting only 1 record in your INSERT statement for the table will result in loss of points and request to resubmit.Notepad file includes code in this order: All commented SQL Code to update the salary of selected Job ClassificationsAll commented SQL Code to update all the salaries of all the employeesAll commented SQL Code to delete an employee of your choiceAll commented SQL Code for queries that return results using Aggregate Functions *****NOTE: IF YOU MADE CHANGES TO YOUR WEEK 1 AND/OR 2 CREATE TABLE CODE, MAKE SURE TO SUBMIT THE CORRECTED CODE WITH THE WEEK 4 ASSIGNMENT SO THAT I HAVE THE MOST CURRENT CODE THAT WILL EXECUTE WITHOUT ERRORS!!!!****** Word Document includes screen shots of the executed code (without errors) in this order:Screen shot of the execution of the code showing results of the Job Title and Employee table joinedScreen shot of the execution of the code to increase selected salariesScreen shot of the execution of the code showing results of the Job Title and Employee table joined after the salary increaseScreen shot of the execution of the code showing results of the Employee tableScreen shot of the execution of the code to increase all employee salariesScreen shot of the execution of the code showing results of the Employee table after the increaseScreen shot of the execution of the code deleting the employee of your choice.Screen shot of the execution of the code showing results of the Employee table after the deletionOne (1) screen shot each of each Query using an aggregate function with query code and results outputNOTE: There will be a minimum of 15 screen shots required for this assignment Note: There will be two (2) Attachments on the Assignments page (Notepad file with Code, Document with Screenshots)

REQUIRED Week 4 Assignment*****NOTE IF YOU MADE CHANGES TO

REQUIRED: Week 4 Assignment*****NOTE: IF YOU MADE CHANGES TO YOUR WEEK 1 AND/OR 2 CREATE TABLE CODE, MAKE SURE TO SUBMIT THE CORRECTED CODE WITH THE WEEK 4 ASSIGNMENT SO THAT I HAVE THE MOST CURRENT CODE THAT WILL EXECUTE WITHOUT ERRORS!!!!******Updating Columns/Using Aggregate functionsREQUIRED: Prepare ALL Code per the Coding Standards document attached with this assignment. Use the database and tables from previous week’s assignment. Write SQL queries using the SQL SELECT statement. NOTE: One SQL Query contains only one SELECT statement and only one FROM statement and may use other statements and clauses to complete the query. See sample queries in the Course Materials forum.REQUIRED: Use Each Assignment Request Below As The ‘Comment’ For Each Query. Copy and paste the Assignment request between 2 multi-line comment indicators. A multi-line comment indicator is a slash and an asterisk – the comments – and then an asterisk and slash: /*comments*/: Example: /* Assignment Request: Write one SQL Query to Increase all employees’ salaries with the selected Job Class by 5.375%. (You select the Job Class of your choice.)*/——————————————————————————————————————Assignment Request: (3 parts to this request)Run a SELECT statement that returns all the records from the Job Title table JOINED to the Employee table.REQUIRED: Create the Code, execute the code without errors and take a screen shot of the code and message showing the code in the current screen. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.Write one SQL Query to Increase all employees’ salaries with the selected Job Class by 4.568%. (You select the Job Classification of your choice.)Run a ‘New’ SELECT statement that returns all the records from the Job Title table JOINED to the Employee table.REQUIRED: Execute the code without errors and take a screen shot of the code and message showing the code in the current screen. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.Should have screenshots of before and after.——————————————————————————————————————Assignment Request: (3 parts to this request)Run a SELECT statement that returns all the records from the EMPLOYEE table.REQUIRED: Create the Code, execute the code without errors and take a screen shot of the code and message showing the code in the current screen. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.Write one SQL Query to Increase all employees’ salaries by 2.091%.REQUIRED: Create the Code, execute the code without errors and take a screen shot of the code and message showing the code in the current screen. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.Run a SELECT statement that returns all the records from the EMPLOYEE table.REQUIRED: Execute the code without errors and take a screen shot of the code and message showing the code in the current screen. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.Should have screenshots of before and after.——————————————————————————————————————Assignment Request: (3 parts to this request)Run a SELECT statement that returns all the records from the EMPLOYEE table.REQUIRED: Create the Code, execute the code without errors and take a screen shot of the code and message showing the code in the current screen. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.Write one SQL Query to Delete employee:

by Employee ID, First Name and Last Name.Run a SELECT statement that returns all the records from the EMPLOYEE table.REQUIRED: Execute the code without errors and take a screen shot of the code and message showing the code in the current screen. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.Should have screenshots of before and after.——————————————————————————————————————Write Queries: REQUIRED: Use Each Assignment Request Below As The ‘Comment’ For Each Query. Copy and paste the Assignment request between 2 multi-line comment indicators. A multi-line comment indicator is a slash and an asterisk – the comments – and then an asterisk and slash: /*comments*/: Example: /* Assignment Request: Write one SQL Query to Increase all employees’ salaries with the selected Job Class by 5.375%. (You select the Job Class of your choice.)*/ REQUIRED: ALL queries must return results that fit the query request. When 3 tables are joined, then all the data must be displayed for all three tables. The number of records will differ depending on the type of join used.——————————————————————————————————————Assignment Request: Write one SQL Query to calculate the average Age for all employees. (Output shows Alias)REQUIRED: Create the Code, execute the code without errors and take a screen shot of the code and message showing the code in the current screen and the results from the query. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.——————————————————————————————————————Assignment Request: Write one SQL Query to calculate the average Salary for all employees. (Output shows Alias)REQUIRED: Create the Code, execute the code without errors and take a screen shot of the code and message showing the code in the current screen and the results from the query. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.——————————————————————————————————————Assignment Request: Write one SQL Query to calculate the maximum salaries for employees by Job Classification. (Output shows Alias)REQUIRED: Create the Code, execute the code without errors and take a screen shot of the code and message showing the code in the current screen and the results from the query. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.——————————————————————————————————————Assignment Request: Write one SQL Query to calculate the maximum salary for all employees. (Output shows Alias) REQUIRED: Create the Code, execute the code without errors and take a screen shot of the code and message showing the code in the current screen and the results from the query. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.——————————————————————————————————————Assignment Request: Write one SQL Query to calculate the minimum salaries for Employees by Job Title. (Output shows Alias)——————————————————————————————————————Assignment Request: Write one SQL Query to calculate the minimum salary for all employees. (Output shows Alias)REQUIRED: Create the Code, execute the code without errors and take a screen shot of the code and message showing the code in the current screen and the results from the query. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.——————————————————————————————————————Assignment Request: Write one SQL Query to Count all employees and GROUP BY Age and Gender. (Output shows Alias)REQUIRED: Create the Code, execute the code without errors and take a screen shot of the code and message showing the code in the current screen and the results from the query. Copy the code to the NotePad file created for this week, paste the screen shot in the Word Document.——————————————————————————————————————DUE MONDAY! WHAT TO SUBMIT: Review the Grading Rubric before you upload and submit the Assignment.Note: There will be two (2) Attachments for this assignment (Please DO NOT ZIP files)Submit only One (1) Notepad attachment with ‘all’ code and One (1) Word document with all screenshots.NOTE: submitting only 1 record in your INSERT statement for the table will result in loss of points and request to resubmit.Notepad file includes code in this order: All commented SQL Code to update the salary of selected Job ClassificationsAll commented SQL Code to update all the salaries of all the employeesAll commented SQL Code to delete an employee of your choiceAll commented SQL Code for queries that return results using Aggregate Functions *****NOTE: IF YOU MADE CHANGES TO YOUR WEEK 1 AND/OR 2 CREATE TABLE CODE, MAKE SURE TO SUBMIT THE CORRECTED CODE WITH THE WEEK 4 ASSIGNMENT SO THAT I HAVE THE MOST CURRENT CODE THAT WILL EXECUTE WITHOUT ERRORS!!!!****** Word Document includes screen shots of the executed code (without errors) in this order:Screen shot of the execution of the code showing results of the Job Title and Employee table joinedScreen shot of the execution of the code to increase selected salariesScreen shot of the execution of the code showing results of the Job Title and Employee table joined after the salary increaseScreen shot of the execution of the code showing results of the Employee tableScreen shot of the execution of the code to increase all employee salariesScreen shot of the execution of the code showing results of the Employee table after the increaseScreen shot of the execution of the code deleting the employee of your choice.Screen shot of the execution of the code showing results of the Employee table after the deletionOne (1) screen shot each of each Query using an aggregate function with query code and results outputNOTE: There will be a minimum of 15 screen shots required for this assignment Note: There will be two (2) Attachments on the Assignments page (Notepad file with Code, Document with Screenshots)