CREATE TABLE table_name_4 (nickname VARCHAR2, institution VARCHAR2)

Post University has what nickname?
SELECT nickname FROM table_name_4 WHERE institution = "post university"
SELECT "nickname" FROM "table_name_4" WHERE "institution" = "post university"