POS 410 Week 4 Individual Assignment SQL Reports


Ask a Question

POS 410 Week 4 Individual Assignment SQL Reports

Regular price $15.00

POS 410 Week 4 Individual Assignment SQL Reports

 

Instructions: Create the following queries in preparation for creating reports:   

  • Write one SQL Query to calculate the average Age for all employees. (Output shows Alias).
  • Write one SQL Query to calculate the average Salary for all employees. (Output shows Alias).
  • Write one SQL Query to calculate the maximum salary for all employees. (Output shows Alias).
  • Write one SQL Query to calculate the minimum salary for all employees. (Output shows Alias).
  • Write one SQL Query to Count all employees and GROUP BY Age and Gender. (Output shows Alias). •  Calculate the number of exempt and non-exempt employees there are, by job code. The results should be sorted in descending order. Take a screenshot of the code and results from each of the bullets above and paste into a Word document. Save all code in a separate Notepad file. Using SQL Server® Data Tools, select one query from the list above and create a report. Join both the Job Title Table and the Employee table in the output and provide subtotals of the Salaries by Job title and a grand total at the end of the report.

Submission of Individual and Learnin

POS 410 Week 4 Individual Assignment SQL Reports

 

Instructions: Create the following queries in preparation for creating reports:   

  • Write one SQL Query to calculate the average Age for all employees. (Output shows Alias).
  • Write one SQL Query to calculate the average Salary for all employees. (Output shows Alias).
  • Write one SQL Query to calculate the maximum salary for all employees. (Output shows Alias).
  • Write one SQL Query to calculate the minimum salary for all employees. (Output shows Alias).
  • Write one SQL Query to Count all employees and GROUP BY Age and Gender. (Output shows Alias). •  Calculate the number of exempt and non-exempt employees there are, by job code. The results should be sorted in descending order. Take a screenshot of the code and results from each of the bullets above and paste into a Word document. Save all code in a separate Notepad file. Using SQL Server® Data Tools, select one query from the list above and create a report. Join both the Job Title Table and the Employee table in the output and provide subtotals of the Salaries by Job title and a grand total at the end of the report.

Submission of Individual and Learning Team Assignments for each assignment, make sure that you provide a single MS Word document that contains the following items:   

  1. A title page including your name. Your name should also be included in the header of the documents. 1.  For Learning Teams, simply include your team name in the header. However, each team member's name should be on the title page.   
  2. All SQL query statements (copy and paste from your query editor). Code is to be manually typed. Due to the large volume of records associated with the Learning Team assignment; the import function may be used.
  3. Copy and paste the results, or provide a screen shot of the resulting views. (Select *)
  4. Results will include the execution status statement results
  5. A short analysis of the query (at least two complete sentences) stating if the query executed as expected Submit your document to the Assignment Files tab.

.

g Team Assignments for each assignment, make sure that you provide a single MS Word document that contains the following items:   

  1. A title page including your name. Your name should also be included in the header of the documents. 1.  For Learning Teams, simply include your team name in the header. However, each team member's name should be on the title page.   
  2. All SQL query statements (copy and paste from your query editor). Code is to be manually typed. Due to the large volume of records associated with the Learning Team assignment; the import function may be used.
  3. Copy and paste the results, or provide a screen shot of the resulting views. (Select *)
  4. Results will include the execution status statement results
  5. A short analysis of the query (at least two complete sentences) stating if the query executed as expected Submit your document to the Assignment Files tab.

.

Questions & Answers

Have a Question?

Be the first to ask a question about this.

Ask a Question