CREATE TABLE table_name_8 (role VARCHAR2, original_broadway_cast VARCHAR2)

What was the role when the original broadway was Adam Riegler?
SELECT role FROM table_name_8 WHERE original_broadway_cast = "adam riegler"
SELECT "role" FROM "table_name_8" WHERE "adam riegler" = "original_broadway_cast"