Table: twenty20_records
Columns: rank
dismissals
player
innings
catches
stumpings

Question: How many dismissals did the player Peter McGlashan have?
SQL: SELECT "dismissals" FROM twenty20_records WHERE "player" = 'Peter McGlashan'

Question: How many stumpings did the player Tim Latham have?
SQL: SELECT MAX("stumpings") FROM twenty20_records WHERE "player" = 'Tim Latham'

Question: List the ranks of all dismissals with a value of 4
SQL: SELECT "rank" FROM twenty20_records WHERE "dismissals" = 4

Question: How many innings had a total of 2 catches and 0 stumpings?
SQL: SELECT COUNT("innings") FROM twenty20_records WHERE "catches" = 2 AND "stumpings" = 0