Table: filmography_2
Columns: year
title
role
producer
director

Question: Which Producer has a Role of rizzette?
SQL: SELECT "producer" FROM filmography_2 WHERE "role" = 'rizzette'

Question: Which Title has a Director of rowell santiago?
SQL: SELECT "title" FROM filmography_2 WHERE "director" = 'rowell santiago'

Question: Which Year has a Producer of viva films, and a Title of magkapatid?
SQL: SELECT "year" FROM filmography_2 WHERE "producer" = 'viva films' AND "title" = 'magkapatid'

Question: Which Director has a Role of melissa?
SQL: SELECT "director" FROM filmography_2 WHERE "role" = 'melissa'