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
Hello, can you find me the names of the furniture with less then 6 components?
assistant
SELECT name FROM furniture WHERE Num_of_Component < 6;
human
Thanks can you find me the names of the furniture with more then 10 components?
assistant
SELECT name FROM furniture WHERE Num_of_Component > 10 ;