how many names or products in the table | Do  you  mean  the  names of products in the products table | how many headquarter in the Manufacturers table
SELECT count ( Headquarter )  from Manufacturers
counting headquarter in the Manufacturers table refers to SELECT COUNT(Headquarter) FROM Manufacturers;