Table: football_gold_coast_2
Columns: team
head_coach
president
home_ground
location

Question: Who is the head coach of the team located in Mudgeeraba?
SQL: SELECT "head_coach" FROM football_gold_coast_2 WHERE "location" = 'mudgeeraba'

Question: Who is the President of the team that has the Head Coach Mark Wakeling?
SQL: SELECT "president" FROM football_gold_coast_2 WHERE "head_coach" = 'mark wakeling'

Question: Who is the Head Coach of the team whose President is Mario Volarevic?
SQL: SELECT "head_coach" FROM football_gold_coast_2 WHERE "president" = 'mario volarevic'

Question: Which team's Head Coach is Steve Beever?
SQL: SELECT "team" FROM football_gold_coast_2 WHERE "head_coach" = 'steve beever'