Find the name of the department that has no students minored in?
create table department (dname varchar, dno varchar, PRIMARY KEY (dname)); create table minor_in (dno varchar, PRIMARY KEY (dno)); create table department (dname varchar, PRIMARY KEY (dname))
select dname from department except select t1.dname from department as t1 join minor_in as t2 on t1.dno = t2.dno