What are the different majors?
select major from student
For each of those, what is the average age?
select avg(age) from student group by major
Also, what is the minimum and maximum for each of those?
select major, avg(age), min(age), max(age) from student group by major