Table schema:
CREATE TABLE Faculty (rank VARCHAR)

Question: What ranks do we have for faculty?
SQL: SELECT DISTINCT rank FROM Faculty