Find the names of nurses who are on call.
create table on_call (nurse varchar, PRIMARY KEY (nurse)); create table nurse (name varchar, employeeid varchar, PRIMARY KEY (name))
select distinct t1.name from nurse as t1 join on_call as t2 on t1.employeeid = t2.nurse