select s.sn,c.cn,c.cg,t.tn from s left join c on s.sid=c.sid left join t on c.cid=t.cid where c.cg>=60 and tn='陈老师'