Database: manufacturer
Question: Give me the names and prices of furnitures which some companies are manufacturing.
SQL:
SELECT t1.name ,  t2.price_in_dollar FROM furniture AS t1 JOIN furniture_manufacte AS t2 ON t1.Furniture_ID  =  t2.Furniture_ID