Who are the students that 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
How many students have more than one credit?
select t1.name from student as t1 join advisor as t2 on t1.id = t2.s_id group by t2.s_id having t1.tot_cred > 1
How many students have more than 115 credits?
select t1.name from student as t1 join advisor as t2 on t1.id = t2.s_id group by t2.s_id having t1.tot_cred > 115