CREATE TABLE furniture (furniture_id NUMBER, name CLOB, num_of_component NUMBER, market_rate NUMBER)
CREATE TABLE manufacturer (manufacturer_id NUMBER, open_year NUMBER, name CLOB, num_of_factories NUMBER, num_of_shops NUMBER)
CREATE TABLE furniture_manufacte (manufacturer_id NUMBER, furniture_id NUMBER, price_in_dollar NUMBER)

Find the names of furnitures whose prices are lower than the highest price.
SELECT t1.name FROM furniture AS t1 JOIN furniture_manufacte AS t2 ON t1.furniture_id = t2.furniture_id WHERE t2.price_in_dollar < (SELECT MAX(price_in_dollar) FROM furniture_manufacte)
SELECT "t1"."name" FROM "furniture" "t1" JOIN "furniture_manufacte" "t2" ON "t1"."furniture_id" = "t2"."furniture_id" AND "t2"."price_in_dollar" < (SELECT MAX("price_in_dollar") FROM "furniture_manufacte")