what is the highest number of dismissals in a match with 8 innings
CREATE TABLE table_19870086_24 (dismissals VARCHAR, innings VARCHAR)
SELECT COUNT(dismissals) FROM table_19870086_24 WHERE innings = 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_19870086_24 (dismissals VARCHAR, innings VARCHAR) Question: what is the highest number of dismissals in a match with 8 innings [/INST] SELECT COUNT(dismissals) FROM table_19870086_24 WHERE innings = 8 </s>