Table: addams_family_casts
Columns: role
original_broadway_cast
closing_broadway_cast
original_us_tour_cast
original_nonequity_tour_cast
original_s_o_paulo_cast
original_lima_cast

Question: Which role had a closing broadway cast of Adam Grupper?
SQL: SELECT "role" FROM addams_family_casts WHERE "closing_broadway_cast" = 'adam grupper'

Question: What was the original US Tour cast when the original broadway was Kevin Chamberlin?
SQL: SELECT "original_us_tour_cast" FROM addams_family_casts WHERE "original_broadway_cast" = 'kevin chamberlin'

Question: What was the original nonequity tour when the original broadway was Kevin Chamberlin?
SQL: SELECT "original_nonequity_tour_cast" FROM addams_family_casts WHERE "original_broadway_cast" = 'kevin chamberlin'

Question: What was the role when the original broadway was Adam Riegler?
SQL: SELECT "role" FROM addams_family_casts WHERE "original_broadway_cast" = 'adam riegler'