What are the first names of the students that minor in the department with DNO 140?
select t2.fname from minor_in as t1 join student as t2 on t1.stuid = t2.stuid where t1.dno = 140
What are the last names of the students that minor in the department with DNO 140?
select t2.lname from minor_in as t1 join student as t2 on t1.stuid = t2.stuid where t1.dno = 140
What are the ages of the students with the last name Lee?
select age from student where lname = 'Lee'
What are the student ids of the students with the last name Smith?
select stuid from student where lname = 'Smith'