How to sum and then find max in sql

[ydu180]

I need to sum the hits of each player and then show the max one. This is my code, but I has syntax problem on this nested sql, can someone help to figure out?

proc sql;
title2"Part 2d";
select distinct PlayerID, min(YearID) label="First Year", sum(H) as Total_Hits
   group by PlayerID
   where Total_Hits=max(Total_Hits);
quit;
title;

[RW9]

What nested SQL?

I can see off the bat that where should be having.

[Ksharp · Accepted solution]

proc sql;
select *
 from (
select sex,sum(height) as total
 from sashelp.class
  group by sex
)
   having  total=max( total);
quit;