List all movie titles and years in which Tommy Chong appeared (hint; sometimes the name column in the actor table contains multiple names, so you want to find any that contain this name)

Question

List all movie titles and years in which Tommy Chong appeared (hint; sometimes the name column in the actor table contains multiple names, so you want to find any that contain this name)

Answer 1

SELECT MovieTitles, MovieYear

FROM ActorTable

WHERE ActorName Like '%Tommy Chong%';