SELECT [CPF], COUNT(*) FROM [NOTAS FISCAIS]
WHERE YEAR(DATA) = 2016 GROUP BY CPF
HAVING COUNT(*) > 2000// 492472718 , 3623344710 , 50534475787
SELECT * FROM [TABELA DE CLIENTES]
WHERE CPF IN('492472718','3623344710','50534475787')Resultado: Marcos Nougeuira, Eduardo Jorge e Abel Silva
