human
Schema:
manufacturer (Manufacturer_ID, Open_Year, Name, Num_of_Factories, Num_of_Shops)
furniture (Furniture_ID, Name, Num_of_Component, Market_Rate)
furniture_manufacte (Manufacturer_ID, Furniture_ID, Price_in_Dollar)
Please answer with SQL.
assistant
Sure, I understand.
human
Show all information for the lowest market-rate furniture item.
assistant
SELECT * FROM furniture ORDER BY market_rate LIMIT 1;
human
What is its id number?
assistant
SELECT furniture_id FROM furniture ORDER BY market_rate LIMIT 1;
human
How many components does it have?
assistant
SELECT Num_of_Component FROM furniture ORDER BY market_rate LIMIT 1 ;