Schema: CREATE TABLE Faculty (rank VARCHAR)
Question: What ranks do we have for faculty?
SQL: SELECT DISTINCT rank FROM Faculty