Table: adelaide_team_song
Columns: club_name
name_of_team_song
basis_for_team_song
first_used_as_team_song
writer_composer

Question: Which team has a song based on  "wee deoch an doris"?
SQL: SELECT "club_name" FROM adelaide_team_song WHERE "basis_for_team_song" = '"Wee Deoch an Doris"'

Question: Name the team that has a song writer named larry spokes.
SQL: SELECT "club_name" FROM adelaide_team_song WHERE "writer_composer" = 'Larry Spokes'

Question: How man teams have a writer named harry angus?
SQL: SELECT COUNT("name_of_team_song") FROM adelaide_team_song WHERE "writer_composer" = 'Harry Angus'

Question: Name the team anthem that was written by quentin eyers and les kaczmarek.
SQL: SELECT "name_of_team_song" FROM adelaide_team_song WHERE "writer_composer" = 'Quentin Eyers and Les Kaczmarek'

Question: How many team songs does fremantle have?
SQL: SELECT COUNT("basis_for_team_song") FROM adelaide_team_song WHERE "club_name" = 'Fremantle'

Question: What is the name of the team song written by ken walther?
SQL: SELECT "basis_for_team_song" FROM adelaide_team_song WHERE "writer_composer" = 'Ken Walther'