SELECT AVG(price)::NUMERIC
FROM products;
avg ------- 28.87 (1 row)
categories customers products orders order_details testproducts