select id,name from student where id in ( select id from score having count(id)>=2 );以上这段语句有没语法错误.SQL语句

select id,name from student where id in ( select id from score having count(id)>=2 );
以上这段语句有没语法错误.
SQL语句

select id,name from student where id in ( select id from score GROUP BY id having count(id)>=2 ); 这应该这样写吧