CREATE TABLE Products (Code NUMBER, Name VARCHAR2, Price NUMBER, Manufacturer NUMBER)
CREATE TABLE Manufacturers (Code NUMBER, Name VARCHAR2, Headquarter VARCHAR2, Founder VARCHAR2, Revenue FLOAT)

Scatter plot to show avg(price) on x axis and manufacturer on y axis.
SELECT AVG(Price), Manufacturer FROM Products GROUP BY Manufacturer
SELECT AVG("Price"), "Manufacturer" FROM "Products" GROUP BY "Manufacturer"