SELECT major FROM Student GROUP BY major ORDER BY count(*) DESC LIMIT 1
Which major has most number of students?
SELECT major FROM Student GROUP BY major ORDER BY count ( * ) DESC LIMIT 1
select major from student group by major order by count ( * ) desc limit value
Which major has most number of students ?