SELECT top 1 CONCAT(P.FNAME, ' ', P.SNAME, ' ', COUNT(E.EPI_NO)) AS Info FROM EPISODES E

JOIN PRESENTERS P ON E.PRES_ID = P.PRES_ID

GROUP BY P.PRES_ID, P.FNAME, P.SNAME

ORDER BY COUNT(E.EPI_NO) DESC

This gives the fname and lname of the Presenter who has done the max number of episodes.