Among the works of Shakespeare, how many of them have the word "Henry" on its title?
works refers to Title; have the word "Henry" on its title refers to Title = '%Henry%'
SELECT COUNT(id) FROM works WHERE Title LIKE '%Henry%'