Hello, how many students are over 18?
select count ( * ) from student where age > 18
Perfect, and how many of those students are majoring in 600?
select count ( * ) from student where major = 600
Yes that are over 18 as well.
select fname, lname from student where age > 18 and major = 600