yes.
select title from film where director = "Walter Hill"
Which studios have produced films with the director "Walter Hill"?
select studio from film where director = "Walter Hill"
What about the ones that haven't?
select studio from film where director ! = "Walter Hill"