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

Find the market shares and names of furnitures which no any company is producing in our records.
SELECT market_rate, name FROM furniture WHERE NOT furniture_id IN (SELECT furniture_id FROM furniture_manufacte)
SELECT "market_rate", "name" FROM "furniture" WHERE NOT "furniture_id" IN (SELECT "furniture_id" FROM "furniture_manufacte")