Table: cricket_matches_2
Columns: scorecard
date
venue
team_1
team_2
result
man_of_the_match

Question: How many scorecards are there for the match on October 28? 
SQL: SELECT COUNT("scorecard") FROM cricket_matches_2 WHERE "date" = 'October 28'

Question: How many venues were there for the match on November 6? 
SQL: SELECT COUNT("venue") FROM cricket_matches_2 WHERE "date" = 'November 6'

Question: What was the venue for the match on October 10? 
SQL: SELECT "venue" FROM cricket_matches_2 WHERE "date" = 'October 10'

Question: Who was the man of the match when the Rockets won by 9 wickets? 
SQL: SELECT "man_of_the_match" FROM cricket_matches_2 WHERE "result" = 'Rockets won by 9 wickets'