what is the rank of Mark | Do you mean the rank of the faculty whose fname is Mark? | exactly
SELECT Rank FROM FACULTY WHERE Fname  =  "Mark"
rank of the faculty = SELECT Rank; whose fname is Mark refers to WHERE Fname = 'Mark';