select S_name from student where s# in (select s# distinct from Take group by s# having count(s#) > 4)

不能修改了 補充一下
我覺得還是樓主用的方法速度會比較快一點!!