use SUCOS_VENDAS SELECT CPF, COUNT() FROM [NOTAS FISCAIS] WHERE YEAR(DATA) = 2016 GROUP BY CPF HAVING COUNT() < 2000
ATÉ 50% OFF
TÁ ACABANDO!
0 dias
0 horas
0 min
0 seg
ATÉ 50% OFF
TÁ ACABANDO!
0 dias
0 horas
0 min
0 seg
use SUCOS_VENDAS SELECT CPF, COUNT() FROM [NOTAS FISCAIS] WHERE YEAR(DATA) = 2016 GROUP BY CPF HAVING COUNT() < 2000
use SUCOS_VENDAS SELECT CPF, COUNT(*) as compras FROM [NOTAS FISCAIS] WHERE YEAR(DATA) = 2016 GROUP BY CPF HAVING COUNT(compras) > 2000