SELECT DNI,COUNT(DNI) AS CANTIDAD_VENTAS FROM facturas
WHERE FECHA_VENTA BETWEEN '2016-01-01' AND '2016-12-31'
GROUP BY DNI
HAVING CANTIDAD_VENTAS > 2000;
SELECT DNI,COUNT(DNI) AS CANTIDAD_VENTAS FROM facturas
WHERE FECHA_VENTA BETWEEN '2016-01-01' AND '2016-12-31'
GROUP BY DNI
HAVING CANTIDAD_VENTAS > 2000;
Excelente Alexei.
Gracias por compartir =)