What is the most common major?
select major from student group by major order by count ( * ) desc limit 1
What is the name of the oldest student?
select lname,fname from student where age = ( select max ( age ) from student )
What is that student's Id?
select stuid from student where age = ( select max ( age ) from student )