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

Find the names of catalog entries with level number 8.
SELECT t1.catalog_entry_name FROM catalog_contents AS t1 JOIN catalog_contents_additional_attributes AS t2 ON t1.catalog_entry_id = t2.catalog_entry_id WHERE t2.catalog_level_number = "8"
SELECT "t1"."catalog_entry_name" FROM "catalog_contents" "t1" JOIN "catalog_contents_additional_attributes" "t2" ON "8" = "t2"."catalog_level_number" AND "t1"."catalog_entry_id" = "t2"."catalog_entry_id"