CREATE TABLE table_1591 ("Character" CLOB, "Indianapolis Concerts" CLOB, "Sarasota" CLOB, "Broadway" CLOB, "Brighton Cast" CLOB)

Name the brighton cast for andrew verala
SELECT "Brighton Cast" FROM table_1591 WHERE "Indianapolis Concerts" = 'Andrew Verala'
SELECT "Brighton Cast" FROM "table_1591" WHERE "Indianapolis Concerts" = 'Andrew Verala'