Name of each manufacturer's product?
SELECT T1.Name, T2.name  FROM products AS T1 JOIN Manufacturers AS T2 ON T1.manufacturer   =   T2.code
manufacturer's product refers to joining products table with manufacturers table on manufacturer code; name of each manufacturer's product involves selecting both manufacturer name and product name;