yes
select avg ( facid ) from faculty
Which rank has the highest number of faculty members?
select rank from faculty group by rank order by count ( * ) desc limit 1
How many ranks have professors
select count ( * ) from faculty where rank = "Professor"