What are the names of departments that have students minoring in them?
select t1.dname from department as t1 join minor_in as t2 on t1.dno = t2.dno
What are all the other department names?
select dname from department except select t1.dname from department as t1 join minor_in as t2 on t1.dno = t2.dno