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

For each director, how many reviews have they received Visualize by bar chart, and could you rank from high to low by the Y-axis?
SELECT director, COUNT(*) FROM Movie AS T1 JOIN Rating AS T2 ON T1.mID = T2.mID GROUP BY T1.director ORDER BY COUNT(*) DESC
SELECT "director", COUNT(*) FROM "Movie" AS "T1" JOIN "Rating" AS "T2" ON "T1"."mID" = "T2"."mID" GROUP BY "T1"."director" ORDER BY COUNT(*) DESC NULLS LAST