What are the first names and last names of the students that minor in the department with DNO 140.
create table student (fname varchar, lname varchar, stuid varchar, PRIMARY KEY (fname)); create table minor_in (stuid varchar, dno varchar, PRIMARY KEY (stuid))
select t2.fname, t2.lname from minor_in as t1 join student as t2 on t1.stuid = t2.stuid where t1.dno = 140