What are the names of students with advisors?
select t1.name from student as t1 join advisor as t2 on t1.id = t2.s_id
Which ones have more than one advisor?
select t1.name from student as t1 join advisor as t2 on t1.id = t2.s_id group by t2.s_id having count(*) > 1