Pls help me solving this....

[RaviCKota]

Hi All,

I have a table Dept_Stores in Denormalized format

Dept_Name Money
Marketing 1500
Sales 2500
Marketing 1500
Production 5000
Sales 3500
Marketing 1000
Sales 3500

My question is , can i use the table which would result from a query

Select Dept_Name , Sum(Money) from Dept_stores group by dept_name; for any other subsequent queries like to find the Max , Min, Avg etc

[RaviCKota]

Let me put my question more clearly,

I want to get the department name (Dept_Name), Money earned or spent (Mny_Erned_Spnt) from the table Dept_Stores, which has the maximum amount of total Mny_Erned_Spnt.....

To put simply I need Max(Sum(Mny_Erned_Spnt))... Can you help me in getting an SQL for this requirement