CREATE TABLE furniture (name VARCHAR, Furniture_ID VARCHAR)
CREATE TABLE furniture_manufacte (Furniture_ID VARCHAR, Price_in_Dollar INT)

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" AS "t1" JOIN "furniture_manufacte" AS "t2" ON "t1"."Furniture_ID" = "t2"."Furniture_ID" AND "t2"."Price_in_Dollar" < (SELECT MAX("Price_in_Dollar") FROM "furniture_manufacte")