CREATE TABLE table_73942 ("School" CLOB, "Location" CLOB, "Founded" FLOAT, "Affiliation" CLOB, "Enrollment" FLOAT, "Nickname" CLOB)

What is the nickname of the University of Alabama?
SELECT "Nickname" FROM table_73942 WHERE "School" = 'University of Alabama'
SELECT "Nickname" FROM "table_73942" WHERE "School" = 'University of Alabama'