CREATE TABLE Catalog_Structure (catalog_level_number NUMBER, catalog_id NUMBER, catalog_level_name VARCHAR2)
CREATE TABLE Catalogs (catalog_id NUMBER, catalog_name VARCHAR2, catalog_publisher VARCHAR2, date_of_publication DATETIME, date_of_latest_revision DATETIME)
CREATE TABLE Attribute_Definitions (attribute_id NUMBER, attribute_name VARCHAR2, attribute_data_type VARCHAR2)
CREATE TABLE Catalog_Contents_Additional_Attributes (catalog_entry_id NUMBER, catalog_level_number NUMBER, attribute_id NUMBER, attribute_value VARCHAR2)
CREATE TABLE Catalog_Contents (catalog_entry_id NUMBER, catalog_level_number NUMBER, parent_entry_id NUMBER, previous_entry_id NUMBER, next_entry_id NUMBER, catalog_entry_name VARCHAR2, product_stock_number VARCHAR2, price_in_dollars DOUBLE PRECISION, price_in_euros DOUBLE PRECISION, price_in_pounds DOUBLE PRECISION, capacity VARCHAR2, length VARCHAR2, height VARCHAR2, width VARCHAR2)

Find the names and publication dates of all catalogs that have catalog level number greater than 5. Bin publication dates into Year interval, and count catalog and group by catalog name.
SELECT date_of_publication, COUNT(date_of_publication) FROM Catalogs AS t1 JOIN Catalog_Structure AS t2 ON t1.catalog_id = t2.catalog_id WHERE catalog_level_number > 5 GROUP BY catalog_name
SELECT "date_of_publication", COUNT("date_of_publication") FROM "Catalogs" "t1" JOIN "Catalog_Structure" "t2" ON "t1"."catalog_id" = "t2"."catalog_id" WHERE "catalog_level_number" > 5 GROUP BY "catalog_name"