SUM(TIME) aggregates the TIME column for each SSN group.
SUM(TIME)
TIME
SSN
MAX(SUM(TIME)) is incorrect because SUM(TIME) is already grouped, and MAX() is trying to apply an additional aggregation incorrectly.
MAX(SUM(TIME))
MAX()