For each user, return the name and the average rating of reviews given by them. Plot them as bar chart.
CREATE TABLE useracct (
    u_id integer,
    name varchar(128)
)

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

CREATE TABLE item (
    i_id integer,
    title varchar(20)
)

CREATE TABLE review (
    a_id integer,
    u_id integer,
    i_id integer,
    rating integer,
    rank integer
)
SELECT 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. Plot them as bar chart. ### Input: CREATE TABLE useracct (
    u_id integer,
    name varchar(128)
)

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

CREATE TABLE item (
    i_id integer,
    title varchar(20)
)

CREATE TABLE review (
    a_id integer,
    u_id integer,
    i_id integer,
    rating integer,
    rank integer
) ### Response: SELECT name, AVG(T2.rating) FROM useracct AS T1 JOIN review AS T2 ON T1.u_id = T2.u_id GROUP BY T2.u_id