How about for the supplier who supplies the least products? | Did  you  want to get the supplier id  who supplies the least products? | I want the average amount purchased and value purchased for the supplier who supplies the least products
SELECT avg ( total_amount_purchased )  , avg ( total_value_purchased )  FROM Product_Suppliers WHERE supplier_id  =   ( SELECT supplier_id FROM Product_Suppliers GROUP BY supplier_id ORDER BY count ( * )  LIMIT 1 ) 
least products supplied refers to MIN(COUNT(product_id)); supplier id who supplies the least products refers to selecting supplier_id after GROUP BY supplier_id and ORDER BY COUNT(*) ASC LIMIT 1; average amount and value purchased for this supplier refers to AVG(total_amount_purchased) and AVG(total_value_purchased);