Posted by: redlotus March 25, 2009
SQL help
Login in to Rate this Post:     0       ?        


Write a query to display the department name, location name, number of
employees, and the average salary for all employees in that department.  Label the columns dname, loc, Number of
People, and Salary, respectively.  Round
the average salary to two decimal places. 
Match on deptno between the EMP and DEPT tables.

I'm totally lost on this one pls help!!!!!!!!1

Read Full Discussion Thread for this article