Query SELECT COUNT(id) AS num_ventas,sucursal,vendedor FROM empresa.ventas GROUP BY sucursal,vendedor HAVING sucursal IS NOT NULL AND vendedor IS NOT NULL, Sat Nov 22 22:35:32 2008
num_ventas
sucursal
vendedor
2
1
1
3
1
2
3
2
1
1
2
2