CREATE TABLE table_28243323_1 (basis_for_team_song VARCHAR2, club_name VARCHAR2)

How many team songs does fremantle have?
SELECT COUNT(basis_for_team_song) FROM table_28243323_1 WHERE club_name = "Fremantle"
SELECT COUNT("basis_for_team_song") FROM "table_28243323_1" WHERE "Fremantle" = "club_name"