Table: warehouse_theatre_staff
Columns: year
chairman
artistic_director
performance_liaison
secretary
business_manager
production_stagemanager
dramaturge
public_relations
first_second_year_rep
male_rep

Question: How many production stage managers worked with Gabriel di Chiara as the Male Rep?
SQL: SELECT COUNT("production_stagemanager") FROM warehouse_theatre_staff WHERE "male_rep" = 'Gabriel Di Chiara'

Question: How many production stage managers worked with secretary Rachel Hartmann?
SQL: SELECT COUNT("production_stagemanager") FROM warehouse_theatre_staff WHERE "secretary" = 'Rachel Hartmann'

Question: Who were the performance liaisons for the dramaturge Chrisena Ricci?
SQL: SELECT "performance_liaison" FROM warehouse_theatre_staff WHERE "dramaturge" = 'Chrisena Ricci'

Question: Who was the first/second year rep. when the performance liaison was Kira Josephson?
SQL: SELECT "first_second_year_rep" FROM warehouse_theatre_staff WHERE "performance_liaison" = 'Kira Josephson'

Question: What year were the first/second year reps Katie Pautler and Devery North?
SQL: SELECT "year" FROM warehouse_theatre_staff WHERE "first_second_year_rep" = 'Katie Pautler and Devery North'

Question: Who was the male rep. when Caroline Rhoads was the artistic director?
SQL: SELECT "male_rep" FROM warehouse_theatre_staff WHERE "artistic_director" = 'Caroline Rhoads'