CREATE TABLE catalog_structure (catalog_level_number NUMBER, catalog_id NUMBER, catalog_level_name CLOB)
CREATE TABLE catalogs (catalog_id NUMBER, catalog_name CLOB, catalog_publisher CLOB, date_of_publication TIME, date_of_latest_revision TIME)
CREATE TABLE attribute_definitions (attribute_id NUMBER, attribute_name CLOB, attribute_data_type CLOB)
CREATE TABLE catalog_contents_additional_attributes (catalog_entry_id NUMBER, catalog_level_number NUMBER, attribute_id NUMBER, attribute_value CLOB)
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 CLOB, product_stock_number CLOB, price_in_dollars NUMBER, price_in_euros NUMBER, price_in_pounds NUMBER, capacity CLOB, length CLOB, height CLOB, width CLOB)

Find the name and attribute ID of the attribute definitions with attribute value 0.
SELECT t1.attribute_name, t1.attribute_id FROM attribute_definitions AS t1 JOIN catalog_contents_additional_attributes AS t2 ON t1.attribute_id = t2.attribute_id WHERE t2.attribute_value = 0
SELECT "t1"."attribute_name", "t1"."attribute_id" FROM "attribute_definitions" "t1" JOIN "catalog_contents_additional_attributes" "t2" ON "t1"."attribute_id" = "t2"."attribute_id" AND "t2"."attribute_value" = 0