CREATE TABLE furniture_manufacte (Furniture_ID VARCHAR2, manufacturer_id VARCHAR2)
CREATE TABLE manufacturer (name VARCHAR2, manufacturer_id VARCHAR2)
CREATE TABLE furniture (Furniture_ID VARCHAR2, num_of_component NUMBER)

Find the name of the company that produces both furnitures with less than 6 components and furnitures with more than 10 components.
SELECT t3.name FROM furniture AS t1 JOIN furniture_manufacte AS t2 ON t1.Furniture_ID = t2.Furniture_ID JOIN manufacturer AS t3 ON t2.manufacturer_id = t3.manufacturer_id WHERE t1.num_of_component < 6 INTERSECT SELECT t3.name FROM furniture AS t1 JOIN furniture_manufacte AS t2 ON t1.Furniture_ID = t2.Furniture_ID JOIN manufacturer AS t3 ON t2.manufacturer_id = t3.manufacturer_id WHERE t1.num_of_component > 10
SELECT "t3"."name" FROM "furniture" "t1" JOIN "furniture_manufacte" "t2" ON "t1"."Furniture_ID" = "t2"."Furniture_ID" JOIN "manufacturer" "t3" ON "t2"."manufacturer_id" = "t3"."manufacturer_id" WHERE "t1"."num_of_component" < 6 INTERSECT SELECT "t3"."name" FROM "furniture" "t1" JOIN "furniture_manufacte" "t2" ON "t1"."Furniture_ID" = "t2"."Furniture_ID" JOIN "manufacturer" "t3" ON "t2"."manufacturer_id" = "t3"."manufacturer_id" WHERE "t1"."num_of_component" > 10