CREATE TABLE Product_Suppliers (total_amount_purchased INT, total_value_purchased INT, supplier_id VARCHAR)

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 NULLS LAST LIMIT 1)