What are the average amount purchased and value purchased for the supplier who supplies the most products.
CREATE TABLE Product_Suppliers (
    total_amount_purchased INTEGER,
    total_value_purchased INTEGER,
    supplier_id VARCHAR
)
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)
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What are the average amount purchased and value purchased for the supplier who supplies the most products. ### Input: CREATE TABLE Product_Suppliers (
    total_amount_purchased INTEGER,
    total_value_purchased INTEGER,
    supplier_id VARCHAR
) ### Response: 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)