select * from Pessoa where SobreNome > ‘Oliveira’ and SobreNome < ‘Rodrigues’;

select * from Pessoa where SobreNome between ‘Oliveira’ and ‘Rodrigues’;

select SobreNome > ‘Oliveira’ and SobreNome < ‘Rodrigues’ from Pessoa;

select Pessoa where SobreNome <> ‘Oliveira’ and SobreNome <> ‘Rodrigues’ group by;