SELECT T1.name ,  avg(T2.rating) FROM useracct AS T1 JOIN review AS T2 ON T1.u_id  =  T2.u_id GROUP BY T2.u_id
For each user, return the name and the average rating of reviews given by them.
SELECT T1.name , avg ( T2.rating ) FROM useracct AS T1 JOIN review AS T2 ON T1.u_id = T2.u_id GROUP BY T2.u_id
select t1 . name , avg ( t2 . rating ) from useracct as t1 join review as t2 on t1 . u_id = t2 . u_id group by t2 . u_id
For each user , return the name and the average rating of reviews given by them .