Questões de Concurso

select p.nome from paciente p, atendimento a

where a.idpaciente = p.id

and a.idmedico = all (select id from medico);

select p.nome from paciente p where not exists (

select id from medico m where id not in (

select idmedico from atendimento where idpaciente = p.id));

select p.nome from paciente p where exists (

select idmedico from atendimento where idpaciente = p.id);

select p.nome from paciente p, atendimento a

where a.idpaciente=p.id group by p.nome

having count(*) = (select count(*) from medico);

select p.nome from paciente p, atendimento a

where a.idpaciente = p.id and

a.idmedico = any (select id from medico);