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