Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE review ( a_id integer, u_id integer, i_id integer, rating integer, rank integer )
TABLE: CREATE TABLE item ( i_id integer, title varchar(20) )
TABLE: CREATE TABLE trust ( source_u_id integer, target_u_id integer, trust integer )
TABLE: CREATE TABLE useracct ( u_id integer, name varchar(128) )

### Question ###
For each user, return the name and the average rating of reviews given by them Plot them as bar chart, and I want to display X-axis from high to low order.

### Accurate SQL ###

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 ORDER BY name DESC