SELECT
	person.person_name
FROM
	program, cast, person, cast_person, cast_person_role
WHERE
	program.cast_id=cast.cast_id
AND
	cast.cast_id =cast_person.cast_id
AND
	person.person_id=cast_person.person_id
AND
	person.person_name = 'bob';