"Bill" in the name select fname, lname, role, name from movie, cast, actor where movie.id = "cast".mid and "cast".aid = actor.id and movie.name like '%Bill%'; The table name "cast" requires quotation Database import: with SQL statements 19 What is the schema of this simplified Movie Database? Actor id first_name last_name gender Movie id name year rank Cast aid mid role The schema constraints Actor(id, first_name, last_name, gender) Cast(aid, mid, role) Movie(id, name, year, rank) Actor.id, Movie.id = primary keys of the corresponding tables Cast.aid = foreign key to Actor.id Cast