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

What are the number of the names of all products?
SELECT Name, COUNT(Name) FROM Products GROUP BY Name
SELECT "Name", COUNT("Name") FROM "Products" GROUP BY "Name"