select CPF, count(CPF) as Contador
from notas_fiscais where year(DATA_VENDA) = 2016
group by CPF having Contador > 2000;
select NOME, CPF from tabela_de_clientes where CPF in (3623344710, 492472718, 50534475787);Retornaram os clientes:
Nome: Marcos Nougeuira CPF: 3623344710 Nome: Eduardo Jorge CPF: 492472718 Nome: Abel Silva CPF: 50534475787
Seriam estes?
