Q74203 – Banco de Dados – Fundação Carlos Chagas 2010

select nome, endereco from candidato where (cep >= ‘57000000’ and <= ‘57999999’) or estado = ‘Sergipe’;

select nome, endereco from candidato where (cep >= ‘57000000’ or <= ‘57999999’) or estado = ‘Sergipe’;

select nome, endereco from candidato where (cep <= ‘57000000’ and >= ‘57999999’) or estado = ‘Sergipe’;

select nome, endereco from candidato where (cep >= ‘57000000’ and <= ‘57999999’) and estado = ‘Sergipe’;

select nome, endereco from candidato where cep >= ‘57000000’ and <= ‘57999999’ or estado = ‘Sergipe’;