What are their names, please?
select LName,Fname from student where major in  ( SELECT Major FROM STUDENT GROUP BY major ORDER BY count ( * )  DESC LIMIT 1 ) 
names refers to LName (Last Name) and Fname (First Name); major with the highest number of students refers to SELECT Major FROM STUDENT GROUP BY major ORDER BY COUNT(*) DESC LIMIT 1;