Below is an instruction that describes a task, paired with an input that provides further context. Write a response that appropriately completes the request.

### Instruction:

Convert text to sql: For each user, return the name and the average rating of reviews given by them. | item : i_id , title | review : a_id , u_id , i_id , rating , rank | useracct : u_id , name | trust : source_u_id , target_u_id , trust | review.i_id = item.i_id | review.u_id = useracct.u_id | trust.target_u_id = useracct.u_id | trust.source_u_id = useracct.u_id | 

### Response:

select _ , avg ( _ ) from _ group by _ | select useracct.name , avg ( review.rating ) from useracct join review on useracct.u_id = review.u_id group by review.u_id