CREATE TABLE Catalogs (date_of_latest_revision VARCHAR)

Find the dates on which more than one revisions were made.
SELECT date_of_latest_revision FROM Catalogs GROUP BY date_of_latest_revision HAVING COUNT(*) > 1
SELECT "date_of_latest_revision" FROM "Catalogs" GROUP BY "date_of_latest_revision" HAVING COUNT(*) > 1