CREATE TABLE table_name_27 (ties VARCHAR, name VARCHAR, lost VARCHAR)

Tell me the total number of ties for name of totals and lost more than 30
SELECT COUNT(ties) FROM table_name_27 WHERE name = "totals" AND lost > 30
SELECT COUNT("ties") FROM "table_name_27" WHERE "lost" > 30 AND "name" = "totals"