CREATE TABLE Movie (mID NUMBER, title CLOB, year NUMBER, director CLOB)
CREATE TABLE Reviewer (rID NUMBER, name CLOB)
CREATE TABLE Rating (rID NUMBER, mID NUMBER, stars NUMBER, ratingDate DATE)

Draw a bar chart for what is the average number of stars that each reviewer awards for a movie?, and show in descending by the Y-axis.
SELECT name, AVG(T1.stars) FROM Rating AS T1 JOIN Reviewer AS T2 ON T1.rID = T2.rID GROUP BY T2.name ORDER BY AVG(T1.stars) DESC
SELECT "name", AVG("T1"."stars") FROM "Rating" "T1" JOIN "Reviewer" "T2" ON "T1"."rID" = "T2"."rID" GROUP BY "T2"."name" ORDER BY AVG("T1"."stars") DESC