Database: manufacturer
Question: Find the market shares and names of furnitures which no any company is producing in our records.
SQL:
SELECT Market_Rate ,  name FROM furniture WHERE Furniture_ID NOT IN (SELECT Furniture_ID FROM furniture_manufacte)