Also if you were to add "Group By 1" to your sub query, it will work.

(select max(count(p2.pres_name)) from president p2 where p1.part = p2.party group by 1)