can you please show me all the advisors?
select advisor from student
show me all advisors who does not have at least two students?
select advisor from student group by advisor having count ( * ) < 2
which advisors have at least two students?
select advisor from student group by advisor having count ( * ) > = 2