SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 4 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 31 Oct 2017 My Price 9.00

Make a T-SQL statement that will count all employees

  1. Make a T-SQL statement that will count all employees in the Employees table.
  2. Modify the query you wrote in the previous step to only show the count of Employees with a Column header of 'Employee Count'.
  3. Make a T-SQL statement using GROUP BY to display the employee count from each department. The display is to be the Department Name followed by the Employee Count. Use those as the column headers.
  4. Modify the query from the previous step to include a HAVING clause that will return rows where the Department Employee count is greater than three.
  5. Make a T-SQL statement using GROUP BY to display the average employee salary for each department. The display is to be the Department Name followed by the Employee Annual Salary Average. Use those as the column headers.
  6. Make a T-SQL statement using GROUP BY to display the maximum and minimum employee salary for each department. The display is to be the Department Name followed by the Maximum Employee Annual Salary and then the Minimum Employee Annual Salary. Use those as the column headers.
  7. Make a T-SQL query to show the average annual salary for all employees (even those without a department).
  8. Make a T-SQL query to show the maximum annual salary for all employees (even those without a department).
  9. Make a T-SQL query to show the minimum annual salary for all employees (even those without a department).
  10. Demonstrate the use of a subquery.

 

I have attached what I have so far.

**THIS IS THE LAST QUERY TO BE CREATED**

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 31 Oct 2017 01:10 PM My Price 9.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)