在MySQL中,以下哪些查询是有效的?( )
Select * from students where marks > avg(marks);
Select * from students order by marks where subject = 'SQL';
Select * from students having subject ='SQL';
Select name from students group by subject, name;
Select group(*) from students;
Select name,avg(marks) from students;
都无效