find the name of the user who gives most reviews
SELECT T1.name FROM useracct AS T1 JOIN review AS T2 ON T1.u_id   =   T2.u_id GROUP BY T2.u_id ORDER BY count ( * )  DESC LIMIT 1
name of the user who gives most reviews refers to MAX(COUNT(reviews)) for a user;