Table: basketball_club_stats
Columns: season
tier
league
pos
postseason
european_competitions

Question: What is the total number of tiers for the postseason of semifinalist?
SQL: SELECT SUM("tier") FROM basketball_club_stats WHERE "postseason" = 'semifinalist'