human
Schema:
product (product_id, product, dimensions, dpi, pages_per_minute_color, max_page_size, interface)
store (Store_ID, Store_Name, Type, Area_size, Number_of_product_category, Ranking)
district (District_ID, District_name, Headquartered_City, City_Population, City_Area)
store_product (Store_ID, Product_ID)
store_district (Store_ID, District_ID)
Please answer with SQL.
assistant
Sure, I understand.
human
what is the dimenson of Plustek MobileOffice D28 Corporate?
assistant
SELECT dimensions FROM product WHERE product = 'Plustek MobileOffice D28 Corporate';
human
how many pages per minute colored in Xerox Travel Scanner 100?
assistant
SELECT pages_per_minute_color FROM product WHERE product = 'Xerox Travel Scanner 100';
human
what is the max page size can be used in Plustek MobileOffice D28 Corporate?
assistant
SELECT max_page_size FROM product WHERE product = 'Plustek MobileOffice D28 Corporate';
human
what is the dpi of Fujitsu fi-6130 A4 Series Scanner?
assistant
SELECT dpi FROM product WHERE product = 'Fujitsu fi-6130 A4 Series Scanner';
human
which product coloured the highest pages in a minute?
assistant
SELECT product , pages_per_minute_color FROM product ORDER by pages_per_minute_color desc LIMIT 1 ;