What are the full names of all students?
select fname, lname from student
Of those, which are minoring in the department with number 140?
select t2.fname, t2.lname from minor_in as t1 join student as t2 on t1.stuid = t2.stuid where t1.dno = 140