Questões de Concurso Comentadas para cvm

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);

@media screen and (max-width: 600px) {

aside, main {width: 100%}

} .

@media screen and (max-width: 600px) {

aside, main {width: 100%}

}

@media screen and (max-width: 600px) {

aside, main {position: absolute}

} .

@media screen and (min-width: 768px) {

aside, main {width: 100%}

}

@media (max-width: 480px) {

aside, main {width: 50%}

} .

{"usuario": 101, "Ana Maria";

"setores": "Financeiro", "Comercial"}

["codigo": 101,"nome": "Ana Maria",

"setor": "Financeiro",

"setor": "Comercial"]

{"codigo": 101,"nome": "Ana Maria",

"setores": ["Financeiro", "Comercial"]}

[{"codigo": "101","nome": "Ana Maria"},

{"setores": ["Financeiro", "Comercial"]}]

{"codigo": "101","nome": "Ana Maria",

"setores": {"Financeiro", "Comercial"}}