quote:

---

Originally posted by Merkin

Yay more homework.

What options have you tried ?


Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson

---

SET NOCOUNT ON

BEGIN TRAN

CREATE TABLE Staff(Name varchar (25), SSN int, Salary money, SupervisorSSN int)
INSERT INTO Staff VALUES ('Biggus Dickus',1,200,2)
INSERT INTO Staff VALUES ('Incontinentia Buttucks',2,200,5)
INSERT INTO Staff VALUES ('Seetonya Face',3,200,2)
INSERT INTo Staff VALUES ('Hugh Jass',4,200,5)
INSERT INTo Staff VALUES ('Amanda Hugenkiss',5,1000,0)



SELECT avg(salary)as st1, count(*) / 1.0 as st2, SupervisorSSN as st3 
INTO avsalnumspersup
FROM staff
GROUP BY SupervisorSSN
ORDER BY SupervisorSSN

select * from avsalnumspersup

SELECT AVG(st2) as [Avnuofsupersuper] FROM avsalnumspersup

SELECT Staff.SSN , Staff.[Name], CAST (st2 AS INT) AS [numb], st1 
FROM avsalnumspersup INNER JOIN Staff 
ON Staff.SSN = St3
ORDER BY Name

DROP TABLE avsalnumspersup
DROP TABLE Staff

ROLLBACK
SET NOCOUNT OFF