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

For each director who directed more than one movie, for each movie title, bin their dates of release into Year interval and count the total number in each bucket using a line chart, sort year from high to low order.
SELECT year, COUNT(year) FROM Movie AS T1 JOIN Movie AS T2 ON T1.director = T2.director WHERE T1.title <> T2.title GROUP BY title ORDER BY year DESC
SELECT "year", COUNT("year") FROM "Movie" AS "T1" JOIN "Movie" AS "T2" ON "T1"."director" = "T2"."director" AND "T1"."title" <> "T2"."title" GROUP BY "title" ORDER BY "year" DESC NULLS LAST