Database: epinions_1
Question: For each user, find their name and the number of reviews written by them.
SQL:
SELECT T1.name ,  count(*) FROM useracct AS T1 JOIN review AS T2 ON T1.u_id  =  T2.u_id GROUP BY T2.u_id