CREATE TABLE furniture_manufacte (Market_Rate VARCHAR, name VARCHAR, Furniture_ID VARCHAR)
CREATE TABLE furniture (Market_Rate VARCHAR, name VARCHAR, Furniture_ID VARCHAR)

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")