CREATE TABLE table_24935743_2 (school VARCHAR, nickname VARCHAR)

What school is nicknamed the panthers?
SELECT school FROM table_24935743_2 WHERE nickname = "Panthers"
SELECT "school" FROM "table_24935743_2" WHERE "Panthers" = "nickname"