Find the names of nurses who are nursing an undergoing treatment.
create table undergoes (assistingnurse varchar, PRIMARY KEY (assistingnurse)); create table nurse (name varchar, employeeid varchar, PRIMARY KEY (name))
select distinct t2.name from undergoes as t1 join nurse as t2 on t1.assistingnurse = t2.employeeid