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

How many movie reviews does each director get Show bar chart, and rank y axis in ascending order.
SELECT director, COUNT(*) FROM Movie AS T1 JOIN Rating AS T2 ON T1.mID = T2.mID GROUP BY T1.director ORDER BY COUNT(*)
SELECT "director", COUNT(*) FROM "Movie" "T1" JOIN "Rating" "T2" ON "T1"."mID" = "T2"."mID" GROUP BY "T1"."director" ORDER BY COUNT(*)