Table: cricket_2006
Columns: player
matches
inns
n_o
runs
high_score
average
100
50
catches
stump

Question:  what's the average where high score is 120
SQL: SELECT "average" FROM cricket_2006 WHERE "high_score" = 120

Question:  what's the player where 50 is 2 and n/o is 0
SQL: SELECT "player" FROM cricket_2006 WHERE "50" = 2 AND "n_o" = 0

Question:  what's the player where inns is 21
SQL: SELECT "player" FROM cricket_2006 WHERE "inns" = 21