How many students have major 600?
select count(*) from student where major = 600
What is the maximum age of these students?
select max(age) from student where major = 600
Please show the minimum age as well.
select max(age), min(age) from student where major = 600