how many trains have express in their names?
SELECT count ( * )  FROM train WHERE name LIKE "%Express%"
trains having 'express' in their names refers to name LIKE '%Express%'; count of such trains refers to COUNT(*);