How can i return the max of a sum by each team? I have a lot of teams and i want to know the maximum of sum total of each team.

This's my query : 

SELECT campaign_id, 
       campaign_identifier, 
       team, 
       campaign_name, 
       Month(time) AS month, 
       Sum (total) AS Total 
FROM   campaign 
WHERE  Year(time) = Year(Now()) 
       AND Month(time) = 12 
GROUP  BY campaign_identi, 
          team 


Thanks.
If am not wrong this is what you need

select team,max(Total)
from
(
SELECT team, 
       Sum (total) AS Total 
FROM   campaign 
WHERE  Year(time) = Year(Now()) 
       AND Month(time) = 12 
GROUP  BY campaign_identi, 
          team 
) A
Group by team