Table: cricket_club
Columns: name
nickname
first_season
location
home_ground_s
coach
captain

Question: What is the location for the club with the nickname the bears?
SQL: SELECT "location" FROM cricket_club WHERE "nickname" = 'Bears'

Question: What is the code nickname where Steve Mayne is the coach?
SQL: SELECT "nickname" FROM cricket_club WHERE "coach" = 'Steve Mayne'

Question: What is the dates where Hillcrest Reserve is the home grounds?
SQL: SELECT "first_season" FROM cricket_club WHERE "home_ground_s" = 'Hillcrest Reserve'

Question: For location Caversham, what is the name of the captain?
SQL: SELECT "captain" FROM cricket_club WHERE "location" = 'Caversham'

Question: With the nickname the swans, what is the home ground?
SQL: SELECT "home_ground_s" FROM cricket_club WHERE "nickname" = 'Swans'