CREATE TABLE table_name_45 (tier NUMBER, postseason VARCHAR2)

What is the total number of tiers for the postseason of semifinalist?
SELECT SUM(tier) FROM table_name_45 WHERE postseason = "semifinalist"
SELECT SUM("tier") FROM "table_name_45" WHERE "postseason" = "semifinalist"