CREATE TABLE Products (Code INT, Name VARCHAR, Price DECIMAL, Manufacturer INT)
CREATE TABLE Manufacturers (Code INT, Name VARCHAR, Headquarter VARCHAR, Founder VARCHAR, Revenue FLOAT)

Bar chart x axis name y axis the number of name
SELECT Name, COUNT(Name) FROM Products GROUP BY Name
SELECT "Name", COUNT("Name") FROM "Products" GROUP BY "Name"