Table schema:
CREATE TABLE table_19870086_24 (dismissals VARCHAR, innings VARCHAR)

Question: what is the highest number of dismissals in a match with 8 innings
SQL: SELECT COUNT(dismissals) FROM table_19870086_24 WHERE innings = 8