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(*) DESC LIMIT 1)
What are the average amount purchased and value purchased for the supplier who supplies the most 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 ( * ) DESC LIMIT 1 )
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 ( * ) desc limit value )
What are the average amount purchased and value purchased for the supplier who supplies the most products .