Which students are male?
select * from student where sex = 'M'
What are their student id numbers?
select stuid from student where sex = 'M'