For each user, return the name and the average rating of reviews given by them.
CREATE TABLE item (
    i_id number,
    title text
)

CREATE TABLE trust (
    source_u_id number,
    target_u_id number,
    trust number
)

CREATE TABLE review (
    a_id number,
    u_id number,
    i_id number,
    rating number,
    rank number
)

CREATE TABLE useracct (
    u_id number,
    name text
)
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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: For each user, return the name and the average rating of reviews given by them. ### Input: CREATE TABLE item (
    i_id number,
    title text
)

CREATE TABLE trust (
    source_u_id number,
    target_u_id number,
    trust number
)

CREATE TABLE review (
    a_id number,
    u_id number,
    i_id number,
    rating number,
    rank number
)

CREATE TABLE useracct (
    u_id number,
    name text
) ### Response: 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