CREATE TABLE table_2293402_2 (left VARCHAR, nickname VARCHAR)

Name the number of left for cardinals
SELECT COUNT(left) FROM table_2293402_2 WHERE nickname = "Cardinals"
SELECT COUNT("left") FROM "table_2293402_2" WHERE "Cardinals" = "nickname"