human
Schema:
device (Device_ID, Device, Carrier, Package_Version, Applications, Software_Platform)
shop (Shop_ID, Shop_Name, Location, Open_Date, Open_Year)
stock (Shop_ID, Device_ID, Quantity)
Please answer with SQL.
assistant
Sure, I understand.
human
What is the minimum quantity of stocks?
assistant
SELECT MIN( Quantity ) FROM stock;
human
What about the average value?
assistant
SELECT AVG ( Quantity ) FROM stock ;