Database: manufacturer
Question: Return the name and id of the furniture with the highest market rate.
SQL:
SELECT name ,  furniture_id FROM furniture ORDER BY market_rate DESC LIMIT 1