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
how many furnitures on the table
assistant
SELECT COUNT( * ) FROM furniture;
human
which furnitures are highest market rate | The name of the furniture that has the highest market rate is Billiard table | what about the highest price of furniture
assistant
SELECT t1.name FROM furniture AS t1 JOIN furniture_manufacte AS t2 ON t1.Furniture_ID = t2.Furniture_ID ORDER by T2.Price_in_Dollar desc LIMIT 1;
human
what is highest num of component?
assistant
SELECT Num_of_Component FROM furniture ORDER by Num_of_Component desc LIMIT 1 ;