For each user, find their name and the number of reviews written by them Show bar chart, and I want to list by the names from low to high.
CREATE TABLE trust (
    source_u_id integer,
    target_u_id integer,
    trust integer
)

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

CREATE TABLE useracct (
    u_id integer,
    name varchar(128)
)

CREATE TABLE item (
    i_id integer,
    title varchar(20)
)
SELECT name, COUNT(*) FROM useracct AS T1 JOIN review AS T2 ON T1.u_id = T2.u_id GROUP BY T2.u_id ORDER BY name
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, find their name and the number of reviews written by them Show bar chart, and I want to list by the names from low to high. ### Input: CREATE TABLE trust (
    source_u_id integer,
    target_u_id integer,
    trust integer
)

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

CREATE TABLE useracct (
    u_id integer,
    name varchar(128)
)

CREATE TABLE item (
    i_id integer,
    title varchar(20)
) ### Response: SELECT name, COUNT(*) FROM useracct AS T1 JOIN review AS T2 ON T1.u_id = T2.u_id GROUP BY T2.u_id ORDER BY name