What are the student ids of students majoring in 600?
select stuid from student where major = 600;
Only show those whose age is 18.
select stuid from student where age > 18 and major = 600;
Just show the first and last names.
select fname, lname from student where age > 18 and major = 600;