exactly
select rank from faculty where fname = "Mark"
how many faculty are presented on the table
select count ( * ) from faculty
what are all the ranks on the table
select distinct rank from faculty