which dno has no stuid associated with it?
select dno from department where dno not in ( select dno from minor_in )
what are the dname's of those DNO's?
select dname from department where dno not in ( select dno from minor_in )
sort the department names alphabetically
select dname from department where dno not in ( select dno from minor_in ) order by dname